Tablespace Offline [message #53230] |
Thu, 05 September 2002 05:14 |
Javier
Messages: 8 Registered: April 2001
|
Junior Member |
|
|
I have a tablespace offline because it has 10 datafiles and one of them is offline (phisicaly the datafile exists, but is in recover state and the database was intalled in NOARCHIVELOG mode). I want export information for this tablespace, is posible put online the tablespace.
Thanks
|
|
|
Re: Tablespace Offline [message #54496 is a reply to message #53230] |
Tue, 19 November 2002 22:31 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
Unfortunatelly, not. Until you bring all the tablespace's datafiles online the tablespace couldn't be changed to online. The datafile headers has to sync and that means to be online and accessible first.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|