Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

Recover Deleted records in Oracle database

Hi all gurus out there
   This might sounds silly, but mistakenly I've deleted and commited data in my database. Following a good practice I know I've should have made a backup, but somtimes things happen.
   Is there anyway that I can recover the deleted data, by all means I really do appreciate any helps. As the data is really important for my company.
   
    Machine : RISC 6000
    OS      : AIX 4.3.3
    Database : Oracle 8.1.5

0
ezree
Asked:
ezree
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
i know that you can "read" the undo log data, but i don't have the documentation here... you can in fact get the undo / redo sql statements by using a specific  package...

BTW, if you post this oracle-specific question directly in the Oracle topic area of EE, you should get more Oracle gurus :-)

CHeers
0
 
ezreeAuthor Commented:
Ok... I think my question in a way has been answered in the LogMiner section of my question.

Thanks Anyway
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - Answered by: angelIII
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
JgouldCommented:
Question has been closed as per recommendation

JGould-EE Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now