Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified
for partitioned tables/indices
- 1 Answers
- 3213 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-19682: file string not in block media recovery context
DRG-11605: URL store: document specified by string not found
TNS-04064: The number of CMCTL sessions exceeds MAX_CMCTL_SESSIONS.
ORA-10657: Lob column to be shrunk does not exist
ORA-30105: 'string' is not a legal boolean for 'string'
RMAN-06582: AS COPY option cannot be used when backing up backupsets
ORA-24062: Subscriber table string inconsistent with queue table string
ORA-27012: skgfrd: read from file failed
QSM-01110: a lossy join in MV, string, between tables, string, not found in query
ORA-29526: created Java class string"string"
RMAN-03098: RMAN-number: stringstring
LCD-00217: failure while processing file parameter [string]
Oracle Errors 
