ORA-01682: read-only DB cannot allocate temporary space in
tablespace string
- 1 Answers
- 3286 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 |
IMG-00554: extra value in rotate operation
DRG-11622: URL store: unknown HTTP error getting string
ORA-12201: TNS:encountered too small a connection buffer
ORA-36776: (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
DRG-12513: valid stop classes are: string
NNO-00116: warning: data type "string" in string load
ORA-09918: Unable to get user privileges from SQL*Net
ORA-14163: subpartition number string: INITRANS value must be less than MAXTRANS value
ORA-13866: Client identifier must be specified
RMAN-05012: trying to start the Oracle instance without parameter files ...
ORA-27370: job slave failed to launch a job of type EXECUTABLE
LPX-00124: attribute value should be one or more tokens
Oracle Errors 
