ORA-01967: invalid option for CREATE CONTROLFILE
- 3 Answers
- 18597 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-14622: Value string already exists in subpartition string
ORA-01908: EXISTS keyword expected
ORA-12007: materialized view reuse parameters are inconsistent
ORA-19728: data object number conflict between table string and partition string in table string
RMAN-00576: PIPE cannot be used with CMDFILE
ORA-32336: cannot use USING NO INDEX to create materialized view "string"."string"
LSX-00167: defining form of "~S" must occur at the top level
ORA-22853: invalid LOB storage option specification
TNS-12590: TNS:no I/O buffer
RMAN-06541: tablespace string will be included in future whole database backups
ORA-22057: bad integer length [string]
ORA-13024: polygon has less than three segments
Oracle Errors 
