ORA-01220: file based sort illegal before database is open
- 1 Answers
- 5425 Views
- I also Faced
- E-Mail Answers
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 |
ORA-10658: Lob column to be shrunk is marked unused
ORA-23483: object "string"."string" not allowed in this operation.
RMAN-08542: channel string: starting proxy archivelog backup at string
ORA-29378: invalid consumer group mapping priorities
ORA-09944: Password entry is corrupt.
DRG-11727: phrase does not have any related terms
PCC-00115: Array required here
NZE-28784: file name translation failure
ORA-23474: definition of "string"."string" has changed since generation of replication support
PLS-00362: invalid cursor return type; 'string' must be a record type
ORA-29893: indextypes without column data do not need the given data type
KUP-04021: field formatting error for field string
Oracle Errors 
