Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified
for partitioned tables/indices
- 1 Answers
- 3155 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 |
RMAN-06074: file string is not an ORACLE datafile
PLS-00626: partitioned/clustered/ordered parameter must be a function argument
ORA-23619: non-Oracle system error: string
ORA-14508: specified VALIDATE INTO table not found
ORA-19211: column 'string', specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type
ORA-31627: API call succeeded but more information is available
DRG-50200: Third-party filter internal error
ORA-30927: Unable to complete execution due to failure in temporary table transformation
PCC-00029: Ambiguous option "string"
ORA-12981: cannot drop column from an object type table
ORA-12495: cannot disable an enabled level, category, or release category
ORA-09799: File label retrieval failed.
Oracle Errors 
