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 |
ORA-16083: LogMiner session has not been created
ORA-30464: no summaries exist
ORA-06423: NETCMN: Error in receiving data
ORA-07571: szrfc: $FIND_HELD failure
ORA-27491: repeat_interval and start_date cannot both be NULL
DRG-10834: upper-case form of section name string too long
ORA-14061: data type or length of an index partitioning column may not be changed
ORA-31502: invalid number supplied for supplemental_processes
TNS-00106: Failed to open log file
TNS-00062: INTCTL: Bad command or syntax error: For help type help/h/?
ORA-16072: a minimum of one standby database destination is required
ORA-13434: GeoRaster metadata cellRepresentation error