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
- 2812 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-01613: instance string (thread string) only has string logs - at least 2 logs required to enable.
ORA-03297: file contains used data beyond requested RESIZE value
ORA-16574: switchover disallowed when required databases are offline
NZE-28780: invalid data access method specified by the parameter
TNS-00510: Internal limit restriction exceeded
TNS-00094: * to status - argument is considered the remote process_name
LSX-00272: BASE64-encoded binary grouped improperly (not 4's)
ORA-30444: rewrite terminated by the sql analyzer
ORA-16108: database is no longer a standby database
ORA-23348: cannot replicate procedure string; only IN parameters supported
ORA-13839: V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.
RMAN-06463: Backup set key string cannot be backed up by proxy.
Oracle Errors 
