recovering truncated table from db back up

Posted on 2012-08-29
Last Modified: 2012-08-29
A table was accidentaly truncated. The data in that table is kind of snapshot and even if we re-run the program that populated the table we will not able to reconcile it to the data the table previously contained before truncating.

Is there a way to recover this data from db backups (level 0 or level 1)

Question by:gs79
    LVL 142

    Accepted Solution

    you might be lucky and have flashback configured and running, so you might not need to "restore" anything, just "flashback" the table:

    otherwise, you will need to restore the database fully from backup (eventually to another host or instance), export the data from there, and import to your table.
    LVL 36

    Assisted Solution

    by:Geert Gruwez
    don't you have a standby running ?
    activate that and copy the data via a db-link

    Author Comment

    Its a Data Warehouse db and we do not have a standby

    Author Comment

    Flashback is enabled and configured but since it was truncated almost 4 weeks it cannot be recovered.
    we do not have a strong case to go alternate route of recovering from full db back up..

    Thanks for your responses..

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    XML error 2 36
    Oracle SQL Update Statement Query Syntax 3 46
    Format Number Field 10 34
    CREATE TABLE syntax 4 33
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now