Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extract information from the transaction log.
Message
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00434732
Message ID:
00436474
Views:
27
Where is located this news group?

>Try searching the comp.databases.oracle.server news group
>I have seen many posts on this...
>


>Short answer with Archive logging on yes, with it of only very recent transactions.
>
>The transaction log on Oracle are called the Redo Logs (these are online)
>then the data is moved into offline Archive Logs.
>
>If you have archive logging turned on you can read the contents with the Log Miner packages.
>
>If not the redo logs will be quickly overwriten so your transactions won't be in there for long.
>
>
>You will want to read the Chapter on "Log Miner"
>it came in Oracle 8i.
>It is a set of packages that allow you to do just that.
>I don't remeber the syntax...
>
>There are also (expensive) third party tools (from revealnet or quest software??) that let you do it on older versions of oracle but I can't remember the name.
>
>I would be very interested in hearing about your solution.
>

>HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform