ORA-01220: file based sort illegal before database is open
- 1 Answers
- 5258 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-24338: statement handle not executed
NID-00321: Proceeding with operation
ORA-01900: LOGFILE keyword expected
ORA-38456: The attribute set "string" is in an inconsistent state.
ORA-30344: number of child cols different from number of parent level cols
DRG-11306: operation cannot be performed on a policy
ORA-27199: skgfpst: sbtpcstatus returned error
ORA-02354: error in exporting/importing data string
ORA-13367: wrong orientation for interior/exterior rings
IMP-00047: unexpected file sequence number; expected number but found number
DRG-12018: Encountered an automatic request for changing proxy - continue?
ORA-13456: GeoRaster cell data error
Oracle Errors 
