I try to recreate a new temp tablespace but I get an error :
SQL> CREATE TEMPORARY TABLESPACE TEMP_NEW TEMPFILE 'F:\Oracle\Oradata\SIVOA\TEMP01.DBF' SIZE 500m autoextend on next 10m maxsize unlimited;
CREATE TEMPORARY TABLESPACE TEMP_NEW TEMPFILE 'F:\Oracle\Oradata\SIVOA\TEMP01.DBF' SIZE 500m autoextend on next 10m maxsize unlimited
*
ERREUR Ó la ligne 1 :
ORA-00604: une erreur s'est produite au niveau SQL rÚcursif 1
ORA-16000: database open for read-only access
This is a physical standby database, it is mounted. I cannot open it. How to create a temporay tablespace in a physical standby database ?
Regards.