SQL*Loader-00823: TREAT AS clause for object tables not
supported for external tables
- 1 Answers
- 2530 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 |
DRG-10000: failed to read column string.string
RMAN-06555: datafile string must be restored from backup created before string
ORA-02736: osnfpm: illegal default shared memory address
RMAN-06559: MAXSIZE must be larger than 1 kb
ORA-19921: maximum number of string rows exceeded
ORA-16551: short string copied
ORA-29549: class string.string has changed, Java session state cleared
ORA-28503: bind value cannot be translated into SQL text for non-Oracle system
QSM-02021: set operator encountered in mv
ORA-29293: A stream error occurred during compression or uncompression.
RMAN-08128: uncataloged backuppiece
ORA-09853: snyRemovePort: bad return code from request.
Oracle Errors 
