Oracle 19.16 Add Temp Tablespace to Standby
Hi, The standby is open read_only with apply but I am unable to create a temp tablespace. The error is -
SYS on gscdwprd >CREATE TEMPORARY TABLESPACE TEMP17 TEMPFILE '/u03/oradata/temp/gscdwprd/gscdwprd_temp17.dbf' SIZE 31G TABLESPACE GROUP TEMP_TS_G1; CREATE TEMPORARY TABLESPACE TEMP17 TEMPFILE '/u03/oradata/temp/gscdwprd/gscdwprd_temp17.dbf' SIZE 31G TABLESPACE GROUP TEMP_TS_G1
ORA-16000: database or pluggable database open for read-only access