BCV_readwrite

select open_mode from v$database;

spool rp.st

select 'alter tablespace ' || tablespace_name || ' add tempfile ' || '''' || file_name ||'''' || ';' from dba_temp_files;

spool off

spool dp.st

select 'alter database tempfile '|| '''' || file_name ||'''' || ' drop;' from dba_temp_files;

spool off

shut immediate

startup nomount

alter database mount standby database;

alter database activate standby database;

shut immediate

startup mount

@dp.st

alter database open;

@rp.st

select open_mode from v$database;

select name from v$tempfile;

exit;

exit;