ORA-01682: read-only DB cannot allocate temporary space in
tablespace string



ORA-01682: read-only DB cannot allocate temporary space in tablespace string..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-26089: LONG column "string" must be specified last

1 Answers  


ORA-07473: snclrd: read error when trying to read sgadef.dbf file.

1 Answers  


DRG-13301: syntax error in token data when expecting string, at line string

1 Answers  


PLS-00640: a pipelined function cannot be called from PL/SQL context

1 Answers  


ORA-13800: concurrent DDL failure on SQL repository objects

1 Answers  


ORA-24272: initialization value must be either F or T

1 Answers  


ORA-29545: badly formed class: string

1 Answers  


NNL-00535: reload [<server_list>] : reload server cache data if there are changes

1 Answers  


PCC-00086: Source file string has zero length

1 Answers  


ORA-01490: invalid ANALYZE command

1 Answers  


ORA-26083: unsupported direct path stream version string

1 Answers  


NCR-03027: NCRO: No remote service session set up yet.

1 Answers  


Categories