01220, 00000, "file based sort illegal before database is open"
// *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 donein memory.
SQL>set line 199
SQL> show parameter SORT_AREA_SIZE
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
sort_area_size integer 65536
SQL> show parameter SORT_AREA_RETAINED_SIZE
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
sort_area_retained_size integer 0
SQL>
ORA-01220: file based sort illegal before database is open
01220, 00000, "file based sort illegal before database is open"// *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 befo