ORA-01967: invalid option for CREATE CONTROLFILE
- 3 Answers
- 19452 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-12170: TNS:Connect timeout occurred
PCC-02301: cannot reopen input file for reading
ORA-09350: Windows 32-bit Two-Task driver unable to allocate context area
ORA-32167: No payload set on the Message
ORA-13006: the specified cell number is invalid
ORA-27470: failed to re-enable "string.string" after making requested change
DRG-12004: Password:
SQL*Loader-00909: Loader views must be loaded (as SYS) for direct path to be used
ORA-39002: invalid operation
DRG-11831: Precondition Failed
DRG-11208: ORACLE_HOME is not set
TNS-00278: Navigator: Failed to Open Log file
Oracle Errors 
