ORA-01967: invalid option for CREATE CONTROLFILE
Answers were Sorted based on User's Feedback
Answer / guest
Cause: An invalid CREATE CONTROLFILE option is present.
Action: Specify only valid CREATE CONTROLFILE options.
Please add more information about this Error
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / jameel ahmed
IF CREATING A CONTROLFILE IN LOWER VERSION LIKE 9.2.0.1.0
BY TAKING A DATAFILE FROM HIGHER VERSION LIKE 9.2.0.8.0
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mayur
For this erro ORA-01967: invalid option for CREATE CONTROLFILE
You just visit below link this is error solution is so simple
https://oracle-techno.blogspot.com/2018/08/ora-01967-invalid-option-for-create.html
| Is This Answer Correct ? | 0 Yes | 1 No |
ORA-22057: bad integer length [string]
ORA-37032: (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
PLS-00721: 'string' formed a non-REF mutually-dependent cycle with 'string'
ORA-14304: List partitioning method expects a single partitioning column
PCC-00039: Unable to open input file "string"
ORA-24851: failed to connect to shared subsystem
IMG-00842: image index allocation failed
PLS-00243: invalid external type specification for SQLNAME
NNC-00409: temporary name service failure
ORA-31014: Attempted to delete the root container
ORA-01492: LIST option not valid
NNO-00630: setting request-processing delay to number seconds