Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Extract information from the transaction log.
Message
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Divers
Thread ID:
00434732
Message ID:
00436474
Vues:
29
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform