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

RMAN-08507: input datafilecopy recid=string stamp=string filename=string

1 Answers  


DRG-50950: circular SQE found

1 Answers  


ORA-24353: user buffer too small to accommodate COBOL display type

1 Answers  


DRG-13302: number of wildcard offsets must be in the range string..string, at line string

1 Answers  


ORA-23309: object string.string of type string exists

1 Answers  






TNS-12631: Username retrieval failed

1 Answers  


ORA-32304: materialized views with user-defined types cannot use prebuilt table

1 Answers  


ORA-39130: Object type string not imported. Base object name conflicts with the master table

1 Answers  


ORA-13454: GeoRaster metadata is invalid

1 Answers  


ORA-07824: sspain: $SETIMR failure

1 Answers  


EXP-00057: Failure to initialize parameter manager

1 Answers  


TNS-00112: Failed to find configuration file name

1 Answers  


Categories