Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    106

    Unanswered: Can we get the data after an oracle user is deleted

    Hi,

    if an oracle user is deleted all the data in the tables under that user is lost.Is there any way of retrieving this data.

    DBA's pl. answer.
    Sachi

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Yes. If you have an export (backup, that is).

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You can also get it if you are running in 9.2 and you have flashback activated.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •