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 |
PLS-00712: illegal option for subprogram string
DRG-50911: invalid first document number string
ORA-23538: cannot explicitly refresh a NEVER REFRESH materialized view ("string")
ORA-28112: failed to execute policy function
ORA-25150: ALTERING of extent parameters not permitted
TNS-04081: Event groups:
ORA-22631: attribute [string] is is not well-formed or does not match the type
PLS-00334: "string" matches table or view without an alias
PCC-01515: FIPS warning: Undeclared host variable "string" at line number in file string
ORA-02359: internal error setting attribute string
PCC-00102: FOR UPDATE is an Oracle extension
ORA-09241: smsalo: error allocating SGA memory