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 |
DRG-52103: the Oracle Text environment could not reset
ORA-13603: The specified parameter string cannot be fetched as a numeric value for task or object string.
ORA-06555: this name is currently reserved for use by user SYS
PLS-00308: this construct is not allowed as the origin of an assignment
ORA-06533: Subscript beyond count
ORA-02154: a tablespace with the name 'string' is found
DRG-10762: index owner does not have access to procedure string
ORA-38469: invalid privilege for an expression set: string
SQL*Loader-00253: DB2 partition number has no significance -- ignored
TNS-00085: * reread - ask the process name to reread parameter files
KUP-04058: unrecoverable error occurred, operation aborted.
ORA-12323: unable to open database (link name string)