How to fix the Oracle error ORA-01682: read-only DB cannot allocate temporary space in tablespace string?

In this post, you’ll learn more about the Oracle ErrorORA-01682: read-only DB cannot allocate temporary space in tablespace string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-01682: read-only DB cannot allocate temporary space in tablespace string

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.

How to fix the Error ORA-01682: read-only DB cannot allocate temporary space in tablespace string ?

You can fix this error in Oracle by following the below steps

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.