Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01682: read-only DB cannot allocate temporary space in
tablespace string
- 1 Answers
- 4168 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 |
O2I-00110: Internal error in OTT component O2I
TNS-01030: The listener supports no services
ORA-30334: illegal dimension level name
TNS-00136: Did not register product/facility for TNS error message
ORA-12020: materialized view string is not registered
IMG-00823: boundary queue pop failed
PLS-00237: invalid BY VALUE indicator or length specification
NID-00137: All datafiles that are not dropped should be readable
NNL-00909: META VIOLATION responses sent: number
NNC-00429: invalid octet string literal "string"
ORA-16614: object has an ancestor that is disabled
ORA-16611: operation aborted at user request
Oracle Errors 
