Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified
for partitioned tables/indices
- 1 Answers
- 3241 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-14050: invalid ALTER INDEX MODIFY PARTITION option
NNF-02003: Unknown NIS error code: string
RMAN-08117: channel string: the autobackup does not contain an SPFILE
ORA-29507: query derived from USING clause found zero or many rows
DRG-11120: failed to write to file string
NMP-00001: value too big
NNL-00262: Request forwarding is currently disabled
ORA-02157: no options specified for ALTER USER
ORA-01171: datafile string going offline due to error advancing checkpoint
ORA-24362: improper use of the character count flag
ORA-28561: unable to set date format on non-Oracle system
ORA-32102: invalid OCI handle
Oracle Errors 
