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
- 2880 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 |
TNS-12521: TNS:listener does not currently know of instance requested in connect descriptor
ORA-14503: only one partition name can be specified
ORA-16623: stale DRC UID sequence number detected
NNO-00628: setting maximum reforwards per query to number
ORA-32761: Turn off Temp LOB Ref Count Feature
PLS-00526: A MAP or ORDER function is required for comparing objects in PL/SQL.
ORA-13515: Error encountered during Database Usage Statistics capture
TNS-12597: TNS:connect descriptor already in use
ORA-14553: cannot perform a lob write operation inside a query
DRG-11826: Proxy Authentication Required
ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE
ORA-06043: NETDNT: message send failure
Oracle Errors 
