ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified
for partitioned tables/indices
- 1 Answers
- 2560 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 |
NNF-04007: Error reading input file
SQL-02115: Code interpretation problem -- check COMMON_NAME usage
ORA-13464: error loading GeoRaster data: string
TNS-12684: encryption/crypto-checksumming: Diffie-Hellman seed too small
ORA-09883: Two Task interface: oratab file does not exist
ORA-01336: specified dictionary file cannot be opened
ORA-30337: multiple JOIN KEY clauses specified for the same parent level
EXP-00081: Exporting access control for table/view "string" as non-DBA.
SQL*Loader-00929: Error parsing insert statement for table string.
ORA-01570: MINEXTENTS must be no larger than the string extents currently allocated
QSM-01610: a lossy join in equivalence, string, between tables, string, not found in query
ORA-31414: error(s) occurred during change table advance
Oracle Errors 
