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
- 2798 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-00976: LEVEL, PRIOR, or ROWNUM not allowed here
NNO-00601: warning: no forwarders, DEFAULT-FORWARDERS-ONLY mode ignored
RMAN-00552: syntax error in command line arguments
ORA-32825: Messaging Gateway agent has not been started
RMAN-08518: channel string: scanning controlfile copy string
ORA-10632: Invalid rowid
ORA-36272: (XSCGMDLAGG04) 'workspace object' is not a valid operator for the AGGREGATION function.
DRG-11400: failed to parse document with key string
DRG-13200: failed to load dictionary file string
ORA-01640: cannot make tablespace read only with active transactions
ORA-12157: TNS:internal network communication error
PROT-00013: Oracle Cluster Registry is in current version
Oracle Errors 
