Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-01355: logminer tablespace change in progress

1 Answers  


ORA-26019: Column string in table string of type string not supported by direct path

1 Answers  


RMAN-03014: implicit resync of recovery catalog failed

1 Answers  


RMAN-03035: Debugging turned off

1 Answers  


ORA-14303: partitions or subpartitions are not in the right order

1 Answers  






TNS-04212: Trace Assistant Internal ERROR: NACOM Type Error

1 Answers  


ORA-19951: cannot modify control file until DBNEWID is completed

1 Answers  


ORA-16591: unknown field "string" in document

1 Answers  


ORA-31615: routine string received this error: string

1 Answers  


CLSR-00524: Resource string is stopping, resource string cannot start

1 Answers  


ORA-23304: malformed deferred rpc at arg string of string in call string, in tid string

1 Answers  


DRG-11854: No File Name Found Or File Not Accessible

1 Answers  






Categories