Re: LogMiner Problem
- From: Melanie Caffrey <melanie_caffrey@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 10 May 2004 10:36:56 -0700 (PDT)
Hello Fahd,
This is a direct quote from the manual:
"You can query the FILENAME, LOW_SCN, and NEXT_SCN
columns in the V$LOGMNR_LOGS view for each redo log
file to determine the range of SCN values contained in
each redo log file."
hth,
Melanie
--- Fahd Mirza <fahd-m@xxxxxxxxxxx> wrote:
> thanks Jo,
> one more thing please, how come I get the starting
> and ending SCN , if i
> want to mine the logs with the help of SCN instead
> of timings? pardon, if
> the question is too simple, but i am confused.
> thanks.
> regards,
> Fahd
>
> ----- Original Message -----
> From: <jo_holvoet@xxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Cc: <oracle-l@xxxxxxxxxxxxx>;
> <oracle-l-bounce@xxxxxxxxxxxxx>
> Sent: Monday, May 10, 2004 3:11 PM
> Subject: Re: LogMiner Problem
>
>
> > Try changing the mask for the timestamp as follows
> :
> >
> > to_date('10-May-2004 14:22:00', 'DD-MON-YYYY
> HH24:MI:SS')
> >
> > mvg/regards
> >
> > Jo
>
----------------------------------------------------------------
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
----------------------------------------------------------------
> To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
