ORA-01682: read-only DB cannot allocate temporary space in
tablespace string
Answer / guest
Cause: Temporary space (usually for sorting) could not be
allocated in either main storage or a tempfile. An attempt
was made to allocate the space from the tablespace named,
but the database is opened read-only. The database open
requires a sort work space.
Action: Either allow sufficient workspace in main storage
(SORT_AREA_SIZE initialization parameter), or create a
temporary tablespace before making the database read-only.
Use ALTER TABLESPACE ADD TEMPFILE statement to add temporary
files to the temporary tablespace.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-09274: szrfc: insufficient role name buffer space
ORA-19009: Missing XMLSchema keyword
ORA-33054: (XSAGDNGL26) In AGGMAP workspace object, a MIN argument of number must be less than a FLOOR argument of number.
ORA-01172: recovery of thread string stuck at block string of file string
TNS-01050: %s
PLS-00391: undefined column 'string' in UPDATE statement
ORA-01029: internal two task error
IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified
ORA-02173: invalid option for DROP TABLESPACE
QSM-01079: DML operation occurred on a table referenced by MV, string
TNS-00249: Unable to read network configuration data from file string with error: string
ORA-00268: specified log file does not exist 'string'