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

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.

Error Type: ORA

• Additional information for ORA-01682: read-only DB cannot allocate temporary space in tablespace [string]01682
Discussions and solutions for Oracle Database Error ORA-01682: read-only DB cannot allocate temporary space in tablespace [string] Developer anwers for Oracle Database Error ORA-01682: read-only DB cannot allocate temporary space in tablespace [string] FAQs for ORA-01682: read-only DB cannot allocate temporary space in tablespace [string] search others tips for ORA-01682: read-only DB cannot allocate temporary space in tablespace [string]