Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01220: file based sort illegal before database is open
- 1 Answers
- 5911 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 |
LFI-00002: Out of memory. string
ORA-36671: (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used.
ORA-02736: osnfpm: illegal default shared memory address
NNL-00245: General request processing is currently enabled
ORA-13014: a topology identifier outside the range of 1 to 8 was specified
ORA-12992: cannot drop parent key column
ORA-06775: TLI Driver: error reading break mode
QSM-01037: Query Rewrite failed to allocate the necessary query join graph
ORA-30766: cannot modify scope for a REF column with a REFERENCES constraint
ORA-23364: Feature not enabled: Advanced replication
NNO-00631: warning: forwarder number has invalid name "string", forwarder ignored
TNS-04231: Trace Assistant WARNING: Assuming Oracle trace format
Oracle Errors 
