ORA-01682: read-only DB cannot allocate temporary space in
tablespace string
- 1 Answers
- 3726 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 |
DRG-50862: failed to create new Oracle object
QSM-01046: complex join back on correlated columns not allowed (string)
ORA-36378: (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.
ORA-13481: the destination type is not supported
ORA-27038: created file already exists
ORA-02172: The PUBLIC keyword is not appropriate for a disable thread
NNL-00561: register <name> [-t<type>] [-d<address>] [-h<hostname>] [-l<listener_name>] : register an object with Oracle Names
ORA-22872: OID INDEX clause not allowed on tables with primary key based object identifiers
QSM-02009: non-inner join
LSX-00204: extra data at end of complex element
ORA-26085: direct path operation must start its own transaction
ORA-31211: DBMS_LDAP: PL/SQL - Invalid LDAP entry dn.
Oracle Errors 
