Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified
for partitioned tables/indices



ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-16148: user requested expiration of managed recovery operation

1 Answers  


ORA-02493: invalid file increment size in NEXT clause

1 Answers  


NZE-29011: Finished message is incorrect.

1 Answers  


ORA-27200: skgfpgo: sbtpcstart returned error

1 Answers  


SQL*Loader-00904: You cannot used the direct path when linked with v5 of the database

1 Answers  






ORA-07488: scgrcl: lock manager not initialized.

1 Answers  


QSM-01125: a more optimal set operator materialized view than string was used to rewrite

1 Answers  


ORA-16577: corruption detected in Data Guard configuration file

1 Answers  


ORA-32159: Cannot set prefetch options for a null Type

1 Answers  


RMAN-06067: RECOVER DATABASE required with a backup or created controlfile

1 Answers  


IMP-00041: Warning: object created with compilation warnings

1 Answers  


ORA-25533: FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified

2 Answers  






Categories