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
- 2821 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-32818: AQ queue string does not exist
QSM-02125: subquery join conditions don't meet requirements for capability
ORA-02855: Number of requests is less than the number of slaves
QSM-01112: WHERE clause of mv, string, is more restrictive than query
TNS-01410: Service "string" has number instances.
ORA-01909: REUSE keyword expected
RMAN-08528: channel string: proxy copy complete, elapsed time: string
ORA-32310: object materialized views must select from an object table
ORA-01968: Only specify RESETLOGS or NORESETLOGS once
LRM-00122: value 'string' for 'string' must be between 'number' and 'number'
ORA-27303: additional information: string
ORA-16745: unable to add DB_UNIQUE_NAME string into The DG_CONFIG list because it is full
Oracle Errors 
