-
Diff between TS Offline and datafile offline
alter database 'd:\users.dbf' offline
Does this cmd initiate a checkpoint before
taking the datafile offline.
When u take a tablespace offline checkpoint is initiated. Is there an important difference between taking tablespace offline and datafile offline. I know there is a difference like taking a TS offline will result in all files associted wihth the TS taken offline. any other major difference
Thanks
Vijay
-
If u have gone through the doc's u willn't have this doubt.
Yes.When ever the TS is taken offline a checkpoint is intiated.
When to take TS and datafile offline refer to manuals.
-
Originally posted by akhadar
If u have gone through the doc's u willn't have this doubt.
Yes.When ever the TS is taken offline a checkpoint is intiated.
When to take TS and datafile offline refer to manuals.
It's repeat. "svijay21" already mentioned that check point is initiated when a TS is taken offline. Only new thing is to urge him to read manuals. That's right.
-nagarjuna
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|