SQL*Loader-00823: TREAT AS clause for object tables not
supported for external tables
- 1 Answers
- 2203 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 |
LPX-00301: error in XPATH evaluation
ORA-25531: MTTR specified is too small: string
LFI-01514: ftell() failed in string
O2I-00103: Two file names refer to the same HFILE file in the INTYPE file
ORA-09830: snyAddPort: failed to perform a remote procedure call.
ORA-01661: tablespace 'string' is already temporary
SQL*Loader-00901: Error logging on to ORACLE:
ORA-24344: success with compilation error
ORA-31441: table is not a change table
ORA-02200: WITH GRANT OPTION not allowed for PUBLIC
ORA-16589: Data Guard Connection process detected a network transfer error
KUP-04053: record number number
Oracle Errors 
