How to recover Temp and Rollback tablespaces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to recover Temp and Rollback tablespaces

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159

    How to recover Temp and Rollback tablespaces

    Can some one help me in the steps involved in recovering rollback and temp tablespaces.

  2. #2
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    why will any one want to recover temporary tablespace ???
    Explain in detail whar r u upto ????
    viraj
    --------
    9i OCA
    A Wise Man Knows How much he doesn't know !!!

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    explain in details... whats ur backup strategy ?

    what type of backups do you have..

    unless u have made any permanent tables in temporary tablespace no need to recover them as its used for sorting and other temporary activities and are dropped as soon as the transaction ends.

    For the rollback tablespace recovery... depends on what kind of backup you have.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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