Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified
for partitioned tables/indices
- 1 Answers
- 3323 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-31675: worker process interrupt for unexpected death of master process
ORA-14107: partition specification is required for a partitioned object
O2I-00113: No HFILE specified
RMAN-08103: channel string: could not locate backup piece: string
ORA-13526: baseline (string) does not exist
LPX-00203: could not read from "~s" (error ~u)
ORA-31517: CDC change table string.string already exists
ORA-31901: the current operation was cancelled by the user
ORA-13419: cannot perform mosaick operation on the specified table column
ORA-19618: cannot name files after restoreValidate has been called
PROT-00013: Oracle Cluster Registry is in current version
ORA-30570: SEGMENT SPACE MANAGEMENT option already specified
Oracle Errors 
