ORA-01682: read-only DB cannot allocate temporary space in
tablespace string
- 1 Answers
- 3760 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 |
ORA-26089: LONG column "string" must be specified last
ORA-07473: snclrd: read error when trying to read sgadef.dbf file.
DRG-13301: syntax error in token data when expecting string, at line string
PLS-00640: a pipelined function cannot be called from PL/SQL context
ORA-13800: concurrent DDL failure on SQL repository objects
ORA-24272: initialization value must be either F or T
ORA-29545: badly formed class: string
NNL-00535: reload [<server_list>] : reload server cache data if there are changes
PCC-00086: Source file string has zero length
ORA-01490: invalid ANALYZE command
ORA-26083: unsupported direct path stream version string
NCR-03027: NCRO: No remote service session set up yet.
Oracle Errors 
