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
is open.
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 |
PLS-00392: Type mismatch in arguments to BETWEEN
ORA-00237: snapshot operation disallowed: controlfile newly created
ORA-07256: sptrap: cannot set up signal handler to catch exceptions.
ORA-01076: multiple logons per process not yet supported
ORA-12150: TNS:unable to send data
EXP-00030: Unexpected End-Of-File encountered while reading input
DRG-52200: invalid state during export
PLS-00581: inheritance is not supported for opaque types
DRG-10506: table does not exist: string
NNL-00563: timed_query [<timestamp>] : query all objects in the Names server's cache
ORA-15100: invalid or missing diskgroup name
ORA-07715: sksadtd: could not dismount archival device (SYS$DISMNT failure)