ORA-14104: RECOVERABLE or UNRECOVERABLE may not be specified for partitioned tables or indices
Cause: CREATE TABLE or INDEX statement used to create a partitioned table or 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.
Cause: CREATE TABLE or INDEX statement used to create a partitioned table or 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.
No comments:
Post a Comment