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-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
PCC-02306: illegal name of C function
PLS-00568: cannot access rows from a non-nested table item
NZE-29136: The allocated buffer is too small.
ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword
ORA-02709: osnpop: pipe creation failed
SQL-02115: Code interpretation problem -- check COMMON_NAME usage
ORA-06437: ssaio: the asynchronous write was unable to write to the database file.
TNS-04209: Trace Assistant Internal ERROR: Type Error
ORA-28173: certificate not provided by proxy
IMP-00069: Could not convert to environment national character set's handle
ORA-07820: sspscn: SYS$CRELNM failure