ORA-01967: invalid option for CREATE CONTROLFILE
- 3 Answers
- 19045 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-26534: collision: tranID number ignored and purged
ORA-02098: error parsing index-table reference (:I)
ORA-31208: DBMS_LDAP: PL/SQL - Invalid LDAP Message.
PCC-02047: CMD-LINE: Option is not allowed inline:
KUP-03999: error occurred while processing a date format: ORA-number: string
ORA-23612: unable to find tablespace "string"
ORA-02140: invalid tablespace name
ORA-22336: table contained 8.0 image format, must specify INCLUDING DATA
ORA-19624: operation failed, retry possible
RMAN-05513: cannot duplicate, controlfile is not current or backup
RMAN-08104: input backupset count=string stamp=string creation_time=string
ORA-13000: dimension number is out of range
Oracle Errors 
