ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified
for partitioned tables/indices
- 1 Answers
- 2558 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-07282: sksaprd: string overflow.
QSM-01085: materialized view, string, has a lossy join between tables, string
ORA-27230: OS system call failure
RMAN-08537: channel string: skipped, autobackup already found
LFI-01500: Error condition on call to OSD function string.
ORA-22879: cannot use the LOB INDEX clause for partitioned tables
ORA-00026: missing or invalid session ID
TNS-00230: Cannot start new pump process: string string Protocol Adapter errors:number
ORA-04033: Insufficient memory to grow pool
DRG-12803: invalid text datatype
ORA-07594: spiip: $GETJPIW failure
PCC-02111: CHAR_MAP option ignored. Only CHAR_MAP=VARCHAR2 allowed for DBMS=V6
Oracle Errors 
