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-30458: 'string.string' cannot be refreshed because the refresh mask is string
NNF-04002: Outputfile already exists
ORA-31407: end_date must be greater than the begin_date
SQL*Loader-00520: lfimknam failed for file (string)
ORA-00101: invalid specification for system parameter DISPATCHERS
PLS-00232: nested packages not permitted
ORA-24183: invalid transformation
ORA-39957: invalid warning category
ORA-39052: cannot specify SKIP_CURRENT on initial start of a job.
RMAN-04009: WARNING from auxiliary database: string
ORA-32132: maximum iterations cannot be changed
ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA