| Taking datafile offline instead of the tablespace [message #308506] |
Mon, 24 March 2008 10:37  |
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. 
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
