ORA-01682: read-only DB cannot allocate temporary space in
tablespace string
- 1 Answers
- 3667 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 |
SQL*Loader-00930: Error parsing insert statement for table string column string.
ORA-32593: database supplemental logging attributes in flux
ORA-23460: missing value for column string in resolution method "string" for "string"."string"."string"
ORA-02714: osnpwr: message send failure
DRG-50932: parser preference initialization failed
TNS-03511: Used parameter files: string
ORA-08238: smsfre: cannot detach from SGA
ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state
ORA-13855: Tracing for service (module/action) string on instance string is already enabled
TNS-04020: CMCTL Version: number.number.number.number.number
ORA-09753: spwat: invalid process number.
TNS-00233: Interchange failed to make contact with destination with errors: string string string
Oracle Errors 
