ORA-01682: read-only DB cannot allocate temporary space in
tablespace string
- 1 Answers
- 3260 Views
- I also Faced
- E-Mail Answers
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-12585: TNS:data truncation
ORA-01326: compatability of 9.0 or greater required to build into the logstream
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-06557: null values are not allowed for any parameters to pipe icd's
ORA-32588: supplemental logging attribute string exists
ORA-12477: greatest lower bound resulted in an invalid OS label
ORA-30017: segment 'string' is not supported in string Undo Management mode
ORA-16641: failure to acquire broker configuration metadata lock
ORA-29361: value string is outside valid range of 0 to 100
RMAN-06087: read-only files may only be skipped in a datafile backup set
PCC-02108: UNSAFE_NULL=YES allowed if MODE=ORACLE and DBMS=V7 or V8
ORA-31462: internal error while accessing metadata
Oracle Errors 
