ORA-14112: RECOVERABLE/UNRECOVERABLE may not be specified
for a partition or subpartition



ORA-14112: RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition..

Answer / guest

Cause: Description of a partition or subpartition found in
CREATE TABLE/INDEX statement contained RECOVERABLE or
UNRECOVERABLE clause which is illegal

Action: Remove offending clause. Use LOGGING or NOLOGGING
instead.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38422: invalid datatype for the attribute: string

1 Answers  


IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified

1 Answers  


QSM-00771: the specified SQL statement cannot be stored in the workload because it has no valid table references

1 Answers  


ORA-30385: specified attribute relationship ('string' determines 'string') exists

1 Answers  


NNL-00516: Displays complete server status

1 Answers  






SQL*Loader-00521: lfilini failed for file (string)

1 Answers  


ORA-02848: Asynchronous I/O package is not running

1 Answers  


LSX-00168: referring form of "~S" must NOT occur at the top level

1 Answers  


ORA-12821: invalid value for INSTANCES

1 Answers  


NZE-29232: the cryptographic engine key initialization failed

1 Answers  


ORA-01173: data dictionary indicates missing data file from system tablespace

1 Answers  


ORA-16729: Validating the value of property string hits error string.

1 Answers  


Categories