Home » RDBMS Server » Server Administration » Tablespace Offline
Tablespace Offline [message #53230] Thu, 05 September 2002 05:14 Go to next message
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 Go to previous message
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

Previous Topic: check constraint
Next Topic: replication and DDL
Goto Forum:
  


Current Time: Fri Sep 20 03:40:13 CDT 2024