alter tbs begin bkup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: alter tbs begin bkup

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

    alter tbs begin bkup

    when this command is executed
    Code:
       alter tablespace users begin backup
    In which location is the datafile corresponding to users tablespace backeup to
    Last edited by svijay21; 08-07-2004 at 03:39 AM.
    Thanks
    Vijay

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    go read the backup and recovery guide, the file is copied anywhere, the header of the datafile is frozen so you are able to take a backup of the file yourself

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Vijay,
    as Davey says, read the concepts as you are misunderstanding what 'Begin backup' does. It is not backing up the TBS, just putting in a state that will enable you to back it up in a consistent state.

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