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_at_aero.com.pk> 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_at_amis.com>
> To: <oracle-l_at_freelists.org>
> Cc: <oracle-l_at_freelists.org>;
> <oracle-l-bounce_at_freelists.org>
> 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon May 10 2004 - 12:39:58 CDT