SQL*Loader-00823: TREAT AS clause for object tables not
supported for external tables



SQL*Loader-00823: TREAT AS clause for object tables not supported for external tables..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07549: sftopn: $OPEN failure

1 Answers  


PCC-00062: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

1 Answers  


ORA-37082: Invalid percent

1 Answers  


SQL*Loader-00262: PIECED keyword (on column string) allowed only when path is direct

1 Answers  


ORA-03237: Initial Extent of specified size cannot be allocated in tablespace (string)

1 Answers  






SQL*Loader-00642: Relative start position > absolute field end position.

1 Answers  


DRG-50932: parser preference initialization failed

1 Answers  


ORA-13628: Insufficient privileges to access the task belonging to user string

1 Answers  


ORA-19592: wrong string conversation type

1 Answers  


ORA-27471: window "string.string" is already closed

1 Answers  


PCB-00234: FOR variable "string" is invalid type

1 Answers  


QSM-01121: materialized view, string, is TRUSTED in ENFORCED integrity mode

1 Answers  


Categories