<div>
Thankyou for the quick reply
</div>


<div>
<div class="content wysiwyg-content">
Guys, I am trying to investigate why when I restore an oracle database from the archive logs I am missing data that should be there.<br />
<br />
I am thinking that maybe logging has been disabled but I need to rule this out<br />
<br />
IS there a query that I can run to see if any tables have been set to NO LOGGING reason is. If I find 1 there may be more.<br />
<br />
Thanks
</div>
</div>


Guys, I am trying to investigate why when I restore an oracle database from the archive logs I am missing data that should be there.

I am thinking that maybe logging has been disabled but I need to rule this out

IS there a query that I can run to see if any tables have been set to NO LOGGING reason is. If I find 1 there may be more.

Thanks

Query for all nologging objects in ORACLE 10.2

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.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.