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

RMAN-00550: parser package failed to load

1 Answers  


ORA-16014: log string sequence# string not archived, no available destinations

1 Answers  


ORA-02838: Unable to arm signal handler for the alarm signal

1 Answers  


PLS-00102: parser stack overflow because nesting is too deep

1 Answers  


LPX-00237: invalid condition section keyword, must be INCLUDE or IGNORE

1 Answers  


ORA-16537: child count exceeded

1 Answers  


ORA-07630: smpdal: $DELTVA failure

1 Answers  


ORA-06748: TLI Driver: cannot allocate t_discon

1 Answers  


DRG-12601: invalid user datastore procedure name: string

1 Answers  


ORA-12335: database (link name string) is not open

1 Answers  


ORA-13386: commit/rollback operation error: [string]

1 Answers  


ORA-04046: results of compilation are too large to support

1 Answers  


Categories