Interested to Buy Any Domain ? << Click Here >> for more details...
SQL*Loader-00480: EXPRESSION may not be used with elements
of a collection.
- 1 Answers
- 2886 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-19567: cannot shrink file string because it is being backed up or copied
ORA-09854: snyPortInfo: bad return code from request.
TNS-12504: TNS:listener was not given the SID in CONNECT_DATA
NNL-00913: Server-generated requests sent: number
DRG-50920: part of phrase not itself a phrase or equivalence
ORA-13457: GeoRaster cell data error
TNS-00298: Request to Navigator: string
PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types
ORA-12912: Dictionary managed tablespace specified as temporary tablespace
NNL-00508: show system_queries [<server_list>] : show system query information
QSM-01079: DML operation occurred on a table referenced by MV, string
ORA-19571: %s recid string stamp string not found in controlfile
Oracle Errors 
