SQL*Loader-00823: TREAT AS clause for object tables not
supported for external tables
- 1 Answers
- 2186 Views
- I also Faced
- E-Mail Answers
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 |
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-13509: error encountered during updates to a SWRF table
ORA-26677: Streams downstream capture process string cannot proceed
LFI-00126: Record format can only be one of Fixed or Variable.
ORA-02493: invalid file increment size in NEXT clause
LSX-00281: referenced ID "~S" is not defined
ORA-30349: specified dimension hierarchy does not exist
ORA-13041: failed to compare tile with element string.string.string
ORA-36650: (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
TNS-01155: Incorrectly specified SID_LIST_string parameter in LISTENER.ORA
ORA-07491: scgrcl: cannot cancel lock request.
ORA-37001: You have one or more attached but unupdated analytic workspaces.
Oracle Errors 
