| table cannot be used in EXCHANGE | |
| Cause: | An attempt was made to issue an ALTER TABLE EXCHANGE PARTITION | SUBPARTITION command, but the non-partitioned table cannot be used in the EXCHANGE because one or more of the following apply:
- it is a typed table - it is a temporary table - it contains ADT columns - it contains nested-table columns - it contains REF columns - it contains array columns - it is an index-organized table - it contains LOB columns - it is a nested table - it is created with row dependency and the partitioned table is not - it is created without row dependency and the partitioned table is |
| Action: | Make sure the non-partitioned table does not violate any of the above restrictions for the ALTER TABLE EXCHANGE PARTITION | SUBPARTITION command. |
| ORA-14133 | |
Custom Search
|
| More Oracle errors | |
| ORA-39808 | The SINGLEROW option must be specified for parent table string. |
| RMAN-06020 | connected to auxiliary database (not started) |
| ORA-01933 | cannot create a stored object using privileges from a role |
| RMAN-10032 | unhandled exception during execution of job step number: string |
| ORA-22312 | must specify either CASCADE or INVALIDATE option |
| QSM-02179 | MV with UNION ALL requires compatibility >= 9.2 |
| PGU-30036 | no ORACLE_HOME environment variable available |
| ORA-16003 | standby database is restricted to read-only access |
| ORA-35562 | (SQLIMP01) The SQL IMPORT command will produce number columns of output, but you have provided number host variables in your INTO clause. |
| RMAN-06012 | channel: string not allocated |
| ORA-14513 | partitioning column may not be of object datatype |
| PLS-01504 | Use of AS phase in CREATE TABLE statement is non_ANSI |
| ORA-22923 | amount of data specified in streaming LOB write is 0 |
| ORA-34896 | (PPMONTHS00) At least 12 month names must be given. Only number were provided. |
| ORA-24241 | source text is in wrapped format |
| ORA-32634 | automatic order MODEL evaluation does not converge |
| PLS-00905 | object string is invalid |
| ORA-14122 | only one REVERSE or NOREVERSE clause may be specified |
| ORA-07404 | sfareq: Timeout occurred waiting for request to complete. |
| LFI-00120 | Unable to parse root filename string. |
| TOP 20 Oracle errors | |
| ORA-12504 | TNS:listener was not given the SERVICE_NAME in CONNECT_DATA |
| RMAN-20079 | full resync from primary database is not done |
| ORA-14411 | The DDL cannot be run concurrently with other DDLs |
| ORA-14760 | ADD PARTITION is not permitted on Interval partitioned objects |
| ORA-10877 | error signaled in parallel recovery slave string |
| ORA-32701 | Hang detected |
| ORA-00838 | Specified value of MEMORY_TARGET is too small, needs to be at least stringM |
| ORA-16665 | timeout waiting for the result from a database |
| ORA-16957 | SQL Analyze time limit interrupt |
| ORA-16664 | unable to receive the result from a database |
| RMAN-08132 | WARNING: cannot update recovery area reclaimable file list |
| ORA-00000 | normal, successful completion |
| ORA-16766 | Redo Apply is stopped |
| ORA-00837 | Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET |
| RMAN-08137 | WARNING: archived log not deleted as it is still needed |
| DIA-48122 | error with opening the ADR block file [string] [string] |
| ORA-47988 | password should contain at least one numeric and one alphabetic character |
| IMP-00057 | Warning: Dump file may not contain data of all partitions of this table |
| ORA-00001 | unique constraint (string.string) violated |
| ORA-55508 | Invalid input to Flashback Transaction Backout |
| Your own TOP 20 Oracle errors | |
| ORA-14132 | table cannot be used in EXCHANGE |