Home » RDBMS Server » Server Administration » Taking datafile offline instead of the tablespace (Oracle 9i)
Taking datafile offline instead of the tablespace [message #308506] Mon, 24 March 2008 10:37 Go to next message
Muddassar
Messages: 28
Registered: March 2007
Junior Member
Hi,
As the purpose of taking a tablespace offline is to make the tablespace as well as all the associated datafiles offline, so that no user can access the tablespace, what is the purpose of taking only the datafiles offline and not the tablespace. i.e,
ALTER TABLESPACE <tbs_name> DATAFILE OFFLINE;
Since the datafiles would be made offline, will keeping the tablespace online allow the users to access the tablespace. If so, what purpose does it serve?
Didnt tried it. Will definitely try it. But would like to have some views on it. Smile
Re: Taking datafile offline instead of the tablespace [message #308510 is a reply to message #308506] Mon, 24 March 2008 10:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can have several datafiles in a tablespace.
So putting one datafile offline allows to access objects that are in other datafiles.

Regards
Michel
Re: Taking datafile offline instead of the tablespace [message #308523 is a reply to message #308510] Mon, 24 March 2008 12:21 Go to previous messageGo to next message
Muddassar
Messages: 28
Registered: March 2007
Junior Member
You can know in which tablespace an object is.
But is it possible to know explicilty in which datafile a particular object resides?
Re: Taking datafile offline instead of the tablespace [message #308525 is a reply to message #308523] Mon, 24 March 2008 12:31 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, with dba_extents.

Regards
Michel
Previous Topic: Datafile Size
Next Topic: ENABLING ARCHIVE LOG
Goto Forum:
  


Current Time: Sat Dec 03 08:25:20 CST 2016

Total time taken to generate the page: 0.04918 seconds