Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified
for partitioned tables/indices
- 1 Answers
- 3244 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-29892: indextypes with array DML do not support the given data type
ORA-19707: invalid record block number - string
NZE-29223: Cannot create certificate chain.
ORA-02295: found more than one enable/disable clause for constraint
ORA-01494: invalid SIZE specified
NNF-04009: Usage: tns2nis <filename>
ORA-36740: A CHILDLOCK was detected in your valueset
ORA-01674: data file string is an old incarnation rather than current file
ORA-30106: reserved for future use
RMAN-06008: connected to recovery catalog database
TNS-00236: Failed to initialize tracing
ORA-06510: PL/SQL: unhandled user-defined exception
Oracle Errors 
