ORA-01220: file based sort illegal before database is open



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

Post New Answer

More Oracle Errors Interview Questions

PLS-00392: Type mismatch in arguments to BETWEEN

2 Answers  


ORA-00237: snapshot operation disallowed: controlfile newly created

1 Answers  


ORA-07256: sptrap: cannot set up signal handler to catch exceptions.

1 Answers  


ORA-01076: multiple logons per process not yet supported

1 Answers  


ORA-12150: TNS:unable to send data

1 Answers  






EXP-00030: Unexpected End-Of-File encountered while reading input

1 Answers  


DRG-52200: invalid state during export

1 Answers  


PLS-00581: inheritance is not supported for opaque types

1 Answers  


DRG-10506: table does not exist: string

1 Answers  


NNL-00563: timed_query [<timestamp>] : query all objects in the Names server's cache

1 Answers  


ORA-15100: invalid or missing diskgroup name

1 Answers  


ORA-07715: sksadtd: could not dismount archival device (SYS$DISMNT failure)

1 Answers  


Categories