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 |
ORA-32733: Error occurred when executing Parallel Oradebug
Recent I have migrated oracle9i to oracle10g(10.2.0.3). I have nested table that table used user define datatype. at a column. when i want to input the valoue at this column ,i cann't the input value.following the error messasge i have got: ORA-24328 illegal attribute value
ORA-07624: smsdes: $DGBLSC failure
NNC-00405: network failure
ORA-31030: Unable to retrieve XML document
ORA-14081: new partition name must differ from the old partition name
ORA-24304: datatype not allowed for this call
ORA-24391: invalid fetch operation
ORA-09206: sfrfb: error reading from file
ORA-16109: failed to apply log data from previous primary
PLS-01470: The escape character in the like-predicate must be a literal or a variable of type CHAR
ORA-34164: (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.