SQL*Loader-00480: EXPRESSION may not be used with elements
of a collection.
- 1 Answers
- 2449 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 |
NZE-29249: an unrecognized state was passed to a cryptographic function
ORA-22331: cannot alter an incomplete type
IMG-00502: invalid scale value
ORA-09976: skxfqdini: Error Creating Port
ORA-00364: cannot write header to new log member
RMAN-04004: error from recovery catalog database: string
ORA-22277: cannot use two different locators to modify the same LOB
RMAN-06170: no controlfile copy found with offline range recid string stamp string datafile string
ORA-27501: IPC error creating a port
DRG-50931: parser not opened
ORA-36970: (XSRELTBL12) workspace object must be a self-relation.
ORA-19588: %s recid string stamp string is no longer valid
Oracle Errors 
