Restoring 2 tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Restoring 2 tables

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Restoring 2 tables

    Hi,

    I have a scenario here where data has been lost from that database and there is a need for 2 tables to be restored to a previous state. We have all the backups on tape but i was wondering wat the best strategy would be to do this?. My thoughts were to restore to a dev box (need to find out if this dev box has Oracle installed!) and then use imp/exp to recreate the tables on the live database. Is this the best way to do it? Is there an easier way?

    Thanks in advance,
    Chucks_k

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    you got it!
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2001
    Posts
    295

    Re: Restoring 2 tables

    Originally posted by Chucks_k
    Hi,

    I have a scenario here where data has been lost from that database and there is a need for 2 tables to be restored to a previous state. We have all the backups on tape but i was wondering wat the best strategy would be to do this?. My thoughts were to restore to a dev box (need to find out if this dev box has Oracle installed!) and then use imp/exp to recreate the tables on the live database. Is this the best way to do it? Is there an easier way?

    Thanks in advance,
    Chucks_k
    Depending on the version, you can consider Logminer and Flashback Query.
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Just incase you didn't think about it... you can just restore the system tablespace along with just the tablespace(s) that the tables reside in. That way you don't have to restore the whole blooming database
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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