Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01220: file based sort illegal before database is open
- 1 Answers
- 5989 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 |
AMD-00111: PROCEDURE string, invalid directory: "string"
ORA-15039: diskgroup not dropped
DRG-11811: Multiple Choices
ORA-02236: invalid file name
DRG-11224: Third-party filter is unable to create or write to temporary file.
ORA-12033: cannot use filter columns from materialized view log on "string"."string"
QSM-02177: MV with UNION ALL in a view must match the view's SELECT list
DRG-10850: CTXRULE indextype does not support the operator
ORA-33005: (XSAGDIMBREAK) Invalid breakout for dimension workspace object.
ORA-22345: recompile type string.string before attempting this operation
ORA-39110: error deleting worker processes
ORA-39033: SUBQUERY data filter is inconsistent with direct path
Oracle Errors 
