SQL*Loader-00823: TREAT AS clause for object tables not
supported for external tables
- 1 Answers
- 2468 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-28557: unknown string for database link to non-Oracle system
TNS-00140: Interchange specified was not found in network tables
ORA-33214: (CINSERT02) The workspace object dimension is too large.
PCC-02387: Expecting an expression of type sql_cursor
TNS-12696: Double Encryption Turned On, login disallowed
ORA-01025: UPI parameter out of range
ORA-27198: skgfpvl: sbtpcvalidate returned error
ORA-37106: (XSVPART06) Invalid partition name number.
ORA-39084: cannot detach job string for user string
ORA-02055: distributed update operation failed; rollback required
ORA-38748: cannot flashback data file string - file is in use or recovery
ORA-08181: specified number is not a valid system change number
Oracle Errors 
