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,609
    Rep Power
    1945
    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
    844
    Rep Power
    387

    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