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-13271: error allocating memory for geometry object
ORA-13631: The task string contains no execution results.
ORA-16596: object not part of the Data Guard broker configuration
ORA-25108: standby lock name space exceeds size limit of string characters
TNS-00237: Failed to refuse connection
ORA-19764: database id string does not match database id string in control file
ORA-29816: object being disassociated is not present
PLS-00711: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared twice
ORA-13111: cannot add topo_geometry layer [string] to topology
PLS-00631: PARTITION-BY and CLUSTER/ORDER-BY clauses must be used with the same function argument
ORA-24813: cannot send or receive an unsupported LOB
ORA-39502: failed to notify CRS of a Startup/Shutdown event [number] (ignored)