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
- 2939 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-00306: limit of string instances in this database
PLS-00536: Navigation through REF variables is not supported in PL/SQL.
ORA-19511: Error received from media manager layer, error text: string
ORA-24202: publisher does not exist for the queue
RMAN-06544: Do you really want to delete the above objects (enter YES or NO)?
RMAN-00575: timeout while trying to write to dbms_pipe
ORA-39144: file name parameter must be specified and non-null
ORA-38311: cannot purge objects owned by other users
ORA-30356: the specified refresh method is not supported in this context
NID-00142: Only changing database name, previous attempt changed dbid to number
ORA-09807: Conversion of label from string to binary failed.
ORA-01877: string is too long for internal buffer
Oracle Errors 
