ORA-01967: invalid option for CREATE CONTROLFILE
- 3 Answers
- 18605 Views
- Oracle, I also Faced
- E-Mail Answers
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-23501: refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
ORA-00105: too many dispatcher configurations
LSX-00255: mismatched parentheses
QSM-01070: equivalence class manager was not found
QSM-01024: materialized view, string, has unknown compile errors
PLS-00210: an OTHERS clause is required in this CASE statement
TNS-00043: The CMANAGER has active connections, do you still want to stop it (y/n)?
PLS-00492: variable or constant initialization may not refer to functions declared in the same package
RMAN-06039: no set newname command has been issued for datafile number
ORA-06406: NETCMN: error sending break message
IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D.
RMAN-06069: the filename for datafile string is missing in the controlfile
Oracle Errors 
