ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified
for partitioned tables/indices
- 1 Answers
- 2545 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: CREATE TABLE/INDEX statement used to create a
partitioned table/index contained RECOVERABLE or
UNRECOVERABLE clause which is illegal
Action: Remove offending clause. [UN]RECOVERABLE is being
deprecated in V8 and will be obsoleted in V9. To duplicate
semantics of UNRECOVERABLE clause, create an object with
NOLOGGING option and then ALTER it specifying LOGGING. To
duplicate semantics of RECOVERABLE clause, create an object
with LOGGING option.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-34342: (MXDSS01) IMPORTANT: Analytic workspace string is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it.
NNL-00224: Scheduled statistic counters to be logged in string
ORA-25150: ALTERING of extent parameters not permitted
ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index
ORA-31038: Invalid string value: "string"
TNS-04014: Current instance string is already started
ORA-00476: RECO process terminated with error
NID-00132: CHECKPOINT_CHANGE# in datafile "string": string in the future of controlfile: string
NID-00452: Succesfully changed database ID.
ORA-33302: (DBVALID01) SEVERE ERROR: Record number multiply used.
LSX-00215: value "~1S" whose total digits exceeds ~2d
ORA-08341: On nCUBE, this command can only be executed from instance 1.
Oracle Errors 
