How to bring rollback tablespace online?
Date: 1996/11/20
Message-ID: <3292B486.4C3E_at_bhp.com.au>#1/1
I tried to rename the datafile of some of the tablespaces. First, i take
the tablespaces offline and that including the rollback tablespace as
well.
SQLDBA> alter tablespace users online;
So, i thought i have to bring the rollback tablespace online first, but
when i tried that i got the same error.
After successfully rename the datafile of one of the tablespace, i tried
to bring that tablespace back online, i get the following errors:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4: 'ORA_TDDE_DISK4:[DBS]TDDE_RBS_1.DBF'
Is there anyway that i can bring rollback tablespace online again?
Patrick Huynh
patrick.huynh.pn_at_bhp.com.au
Received on Wed Nov 20 1996 - 00:00:00 CET