Re: Log1xxx.ora - open and view

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 20 Sep 1999 17:14:11 +0100
Message-ID: <937844508.15840.0.nnrp-07.9e984b29@news.demon.co.uk>

But if you really know your hex,
you can do things like:

alter system dump logfile '{file name}'

if you want to see all the change records. The results get placed in the trace file - but expect the trace to be up to 5 times the size of the original.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Connor McDonald wrote in message <37E5FD0A.631C_at_yahoo.com>...
>michael.vad_at_mobilixnet.dk wrote:
>>
>> Hi
>>
>> How do I open and view the Oracle log files placed in the DATABASE folder
?
>>
>> Thanks
>> Michael Vad
>
>If you are referring to the online redo logs - you cannot do that
>directly. Oracle 8.1 has a tool called LogMiner which will allow you to
>interrogate the logs.
Received on Mon Sep 20 1999 - 11:14:11 CDT