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-09939: Restoration of signal handlers failed.
ORA-30113: error when processing file 'string'
ORA-22904: invalid reference to a nested table column
ORA-38605: FI not enough memory(stringK) for candidate generation(stringK)
ORA-07474: snclrd: close error, unable to close sgadef.dbf file.
ORA-12043: invalid CREATE MATERIALIZED VIEW option
IMG-00861: assert failure, inconsistency in area merge operation
ORA-14326: Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
PLS-00425: in SQL, function argument and return types must be SQL type
ORA-39068: invalid master table data in row with PROCESS_ORDER=string
TNS-00533: Connection dissolved or not yet made
ORA-25463: table alias not specified