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-13620: The task or object string is read-only and cannot be deleted or modified.
SQL*Loader-00416: SDF clause for field string in table string references a non existent field.
RMAN-08005: new incarnation of database registered in recovery catalog
ORA-29703: error occurred in global enqueue service operation
DRG-13008: cannot remove the DEFAULT sub lexer
ORA-15107: missing or invalid ASM disk name
ORA-31457: maximum length of description field exceeded
LSX-00002: root element is not <schema>
ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
ORA-07486: scg_get_inst: cannot convert(get) instance number lock.
ORA-30204: buffer is not large enougth
ORA-09285: sllfop: unrecognizable processing option, incorrect format