Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 492
  • 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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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