DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Incidently Delete Rows from a Table

  1. 03-23-2002, 10:08 AM #1
    sethi
    sethi is offline Junior Member
    Join Date
    Apr 2001
    Location
    Ludhiana (Punjab) India
    Posts
    36

    Exclamation

    Hello Friends

    I am having Oracle 8.1.7 Database running on Windows NT. During work i incidently delete rows from one of my stockledger register and then commit it.

    Database is running in ARCHIVELOG MODE and i have full backup till the morning. The table has droped in the noon.

    So what could i do :

    whether i just export that table from my last backup and then apply archivelog or what else

    Thanks in Advance.

    Sethi
    Reply With Quote Reply With Quote
  2. 03-23-2002, 11:38 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You will have to restore your database from the last backup (hopefully to another box), restore up to the point which you deleted rows, export the table, and import the table to your production instance.

    Alternatively, you could use logminer to retrieve the rows that were deleted.
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 03-23-2002, 01:30 PM #3
    gpsingh
    gpsingh is offline Senior Member
    Join Date
    Feb 2001
    Posts
    389
    no need to export or restore backup,
    just if u remember the time , keep safe the archived files and log files ,
    configure ur database or any other 8.1.7 database for using logminer, and get the undo for the table during that time from the archived files.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width