ORA-01220: file based sort illegal before database is open
Answer / guest
Cause: A query issued against a fixed table or view required
a temporary segment for sorting before the database was
open. Only in-memory sorts are supported before the database
Action: Re-phrase the query to avoid a large sort, increase
the values of the SORT_AREA_SIZE and/or
SORT_AREA_RETAINED_SIZE initialization parameters to enable
the sort to be done in memory.
Please add more information about this Error
|Is This Answer Correct ?||2 Yes||0 No|
ORA-33447: (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.
ORA-19593: datafile number string already included as string
ORA-24407: connection pool already exists
TNS-12232: TNS:No path available to destination
IMP-00070: Lob definitions in dump file are inconsistent with database.
SQL*Loader-00505: error reading LOBFILE
ORA-07826: sspscm: SYS$GETDVIW failure
ORA-37073: (XSMCSESS01) Applied relation workspace object must be dimensioned by dimension workspace object.
ORA-24017: cannot enable enqueue on QUEUE, string is an exception queue
QSM-02133: agg(expr) requires correspondng MIN(expr) function
RMAN-06057: a standby controlfile cannot be included along with a current controlfile
ORA-02728: osnfop: access error on oracle executable