Thread: Help Needed

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2013
    Posts
    1
    Rep Power
    0

    Help Needed


    Hi guys.
    i am using oracle sql 11g and needed a bit of help. I deleted a table ( only deleted the content/row BUT NOT DROP TABLE). Is there anyway of getting the content of these table back.
    all help is appreciated
  2. #2
  3. Lord of the Dance
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Oct 2003
    Posts
    3,663
    Rep Power
    1958
    Can I assume you don't have any backups?

    Did you try to search on google for this topic?
    e.g.: www.google.com/#q=oracle+restore+deleted+rows
  4. #3
  5. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    857
    Rep Power
    388

    Cool


    Originally Posted by oracle_dummy
    Hi guys.
    i am using oracle sql 11g and needed a bit of help. I deleted a table ( only deleted the content/row BUT NOT DROP TABLE). Is there anyway of getting the content of these table back.
    all help is appreciated
    Do you have Flash Recovery turned on?
    If you do you can FLASHBACK TABLE.

IMN logo majestic logo threadwatch logo seochat tools logo