Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-13620: The task or object string is read-only and cannot be deleted or modified.

1 Answers  


SQL*Loader-00416: SDF clause for field string in table string references a non existent field.

1 Answers  


RMAN-08005: new incarnation of database registered in recovery catalog

1 Answers  


ORA-29703: error occurred in global enqueue service operation

1 Answers  


DRG-13008: cannot remove the DEFAULT sub lexer

1 Answers  


ORA-15107: missing or invalid ASM disk name

1 Answers  


ORA-31457: maximum length of description field exceeded

1 Answers  


LSX-00002: root element is not <schema>

1 Answers  


ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")

1 Answers   Satyam,


ORA-07486: scg_get_inst: cannot convert(get) instance number lock.

1 Answers  


ORA-30204: buffer is not large enougth

1 Answers  


ORA-09285: sllfop: unrecognizable processing option, incorrect format

1 Answers  


Categories