Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01682: read-only DB cannot allocate temporary space in
tablespace string
- 1 Answers
- 4148 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 |
NNL-00855: Slowest rename processing time: string
NNL-00954: Hash tables created: number
ORA-30466: can not find the specified workload string
ORA-27155: could not execute file
ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.
RMAN-06089: archived log string not found or out of sync with catalog
LPX-00400: an internal error has occurred in XPATH
ORA-01038: cannot write database file version string with ORACLE version string
ORA-33265: (DBERRBSZ) Analytic workspace string cannot be opened. Tablespace blocksize number does not match database cache size number.
DRG-51203: found doc ids without mappings during get maps
TNS-04064: The number of CMCTL sessions exceeds MAX_CMCTL_SESSIONS.
ORA-25101: duplicate REBUILD option specification
Oracle Errors 
