<div>
Its a Data Warehouse db and we do not have a standby
</div>


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

<div>
Flashback is enabled and configured but since it was truncated almost 4 weeks it cannot be recovered. <br />
we do not have a strong case to go alternate route of recovering from full db back up..<br />
<br />
Thanks for your responses..
</div>


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..

<div>
<div class="content wysiwyg-content">
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. <br />
<br />
Is there a way to recover this data from db backups (level 0 or level 1)<br />
<br />
Thanks,
</div>
</div>


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)

Thanks,

recovering truncated table from db back up

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.