tablespace in backup mode??? Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: tablespace in backup mode???

  1. #1
    Join Date
    Oct 2000
    If you need to check to see if a tablespace is still in backup mode ( alter tablespace tablespace_name begin backup), do you check by looking at status in dba_tablespaces?


  2. #2
    Join Date
    Nov 2000
    select, b.status
    from v$backup b, v$datafile df
    where df.file#=b.file#

    will give you the datafile and whether it is being backed up or not (in backup mode). "NOT ACTIVE" means that the tablespace is not in backup mode, where "ACTIVE" means that it is.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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