Diff between TS Offline and datafile offline
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Diff between TS Offline and datafile offline

  1. #1
    Join Date
    Apr 2004
    Location
    chennai
    Posts
    9

    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

  2. #2
    Join Date
    May 2001
    Posts
    736
    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    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
  •  


Click Here to Expand Forum to Full Width