Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-01220: file based sort illegal before database is open



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

Post New Answer

More Oracle Errors Interview Questions

ORA-33447: (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.

1 Answers  


ORA-19593: datafile number string already included as string

1 Answers  


ORA-24407: connection pool already exists

1 Answers  


TNS-12232: TNS:No path available to destination

1 Answers  


IMP-00070: Lob definitions in dump file are inconsistent with database.

0 Answers  






SQL*Loader-00505: error reading LOBFILE

1 Answers  


ORA-07826: sspscm: SYS$GETDVIW failure

1 Answers  


ORA-37073: (XSMCSESS01) Applied relation workspace object must be dimensioned by dimension workspace object.

1 Answers  


ORA-24017: cannot enable enqueue on QUEUE, string is an exception queue

1 Answers  


QSM-02133: agg(expr) requires correspondng MIN(expr) function

1 Answers  


RMAN-06057: a standby controlfile cannot be included along with a current controlfile

1 Answers  


ORA-02728: osnfop: access error on oracle executable

1 Answers  






Categories