SQL*Loader-00823: TREAT AS clause for object tables not supported for external tables
Cause: A TREAT AS clause was specified in the INTO TABLE clause for an object table in the SQL*Loader control file and the EXTERNAL_TABLES command line parameter was set to either EXECUTE or GENERATE_ONLY. External tables can be used to load the data, but SQL*Loader does not generate the correct SQL statements to do this.
Action: Use SQL*Loader direct path or SQL*Loader conventional path to load the table.
SQL*Loader-00901
Custom Search


More Oracle errors
O2F-00321Error opening the OUTTYPE file for writing
CLST-02203Host name string is already assigned to node number string.
ORA-12089cannot online redefine table "string"."string" with no primary key
DRG-12017A redirection may change the behavior of this method - proceed anyway?
QSM-01335query rewrite not possible because query has an LOB column
ORA-24245invalid network privilege
IMG-00522invalid format for parameter value
TNS-02525encryption/crypto-checksumming: self test failed
PCB-00311Datatype equivalencing is an Oracle extension
RMAN-06807compression algorithm cannot be used because database compatibility is less than string
ORA-13840Concurrent DDL Error in create SQL profile operation.
ORA-09240smpalo: error allocating PGA memory
ORA-14156invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause
TNS-01102TNS application contacted was not the listener
TNS-00516Permission denied
NNO-00623setting auto-refresh retry interval to number seconds
O2I-00124Error opening the INITFILE file for writing
ORA-00281media recovery may not be performed using dispatcher
ORA-27365job has been notified to stop, but failed to do so immediately
DIA-48197OS command to get the file status failed




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
SQL*Loader-00823TREAT AS clause for object tables not supported for external tables