SQL*Loader-00480: EXPRESSION may not be used with elements
of a collection.
- 1 Answers
- 2338 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The EXPRESSION keyword is followed by a required SQL
string expression and is used to load a column with the
result of the SQL string expression instead of with a value
from the input data file. However, this capability is not
allowed with elements of a collection.
Action: Remove the EXPRESSION keyword and associated SQL
string from the collection element in the control file.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-25185: index column other than last can not be specified for INCLUDE clause
ORA-14257: cannot move partition other than a Range or Hash partition
IMG-00830: boundary queue is full
ORA-00091: LARGE_POOL_SIZE must be at least string
NZE-29225: Certificate already installed.
ORA-17622: failed to deregister the memory with Oracle Disk Manager library
LSX-00148: annotation must come first in "~S"
ORA-07747: slemrd: $READ failure
ORA-32619: incorrect use of MODEL ITERATION_NUMBER
ORA-07685: sou2os: supervisor stack set error
ORA-21561: OID generation failed
ORA-33290: (DBERR17) Analytic workspace string cannot be attached in the mode you requested because another user has it attached in an incompatible mode.
Oracle Errors 
