Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2003
    Posts
    24

    Unhappy Unanswered: Help!!, How can restore deleted rows?

    Hello, unfortunately I deleted rows that are very important for me. I hope that exists a way to restore this rows.

    I don't have backup.

    Please, can somebody help me!!!

    I will thank you very much.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    Do you have an export of the table in question?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jan 2003
    Posts
    24
    No, I don't, .

    Exists a transaction log?

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    do a search on logminer, it should be able to retrieve the data provided you have the archive logs and know roughly what time the deletions occurred.

    Alan

  5. #5
    Join Date
    Jan 2003
    Posts
    24
    Originally posted by AlanP
    do a search on logminer, it should be able to retrieve the data provided you have the archive logs and know roughly what time the deletions occurred.

    Alan
    Thank you very much!!!!

  6. #6
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow Log Miner

    Hi
    Try using LogMiner, and it comes free with Oracle.
    It enables you to view all the SQLs ran against the DB, and also provides you with the option to create the SQLs to retrieve the old data from the log files.
    Thanx and Regards
    Aruneesh

  7. #7
    Join Date
    Jan 2003
    Posts
    24
    Ok, thanks. But now a want to undo some deleted rows, so I am using the sql_undo column from v$logmnr_contents.

    But, I have a problem. One of the columns is a BLOB type and cannot be restored in this way.

    I think that I cannot restore this column.
    Last edited by nmoreno; 07-28-03 at 18:11.

  8. #8
    Join Date
    Nov 2012
    Posts
    1

    Retrieve Deleted Rows

    TRY
    select * from TABLE_NAME AS OF TIMESTAMP TO_TIMESTAMP('15/11/2012 12:00:00','DD/MM/YYYY HH24:MI: SS');

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You never get a second chance to make a first impression!

    please NOTE that this thread is only NINE+ years old!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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