[prev in list] [next in list] [prev in thread] [next in thread]
List: odtug-sqlplus-l
Subject: RE: from where to get the latest scn of database
From: "Kamal Mutneja" <kamal.mutneja () india ! birlasoft ! com>
Date: 2004-12-30 12:14:17
Message-ID: F001.005F11CB.20041230041417 () fatcity ! com
[Download RAW message or body]
Dear Mr Paul,
Hi,
Thanks for your advise.. In fact I was looking for a DBa related list only but could \
not find it. I am trying to subscribe that.
Thank you very much for your advise.
Regards
Kamal Mutneja
-----Original Message-----
Paul Dorsey
Sent: Thursday, December 30, 2004 5:28 PM
To: Multiple recipients of list ODTUG-SQLPLUS-L
Kamal,
You might want to join Oracle-L.
The number of DBAs on this list is pretty small.
I think you would get better, faster answers to your questions.
Paul
-----Original Message-----
Kamal Mutneja
Sent: Thursday, December 30, 2004 6:09 AM
To: Multiple recipients of list ODTUG-SQLPLUS-L
Hi
We can get checkpoint_change# even from v$database . I was looking for scn word !! \
earlier.
Thanks for help.
Regards
Kamal
-----Original Message-----
Deepak Panda
Sent: Thursday, December 30, 2004 3:58 PM
To: Multiple recipients of list ODTUG-SQLPLUS-L
Hi,
Please use
select CHECKPOINT_CHANGE#,CHECKPOINT_TIME from v$datafile;
Hope this works for you.
Regards
Deepak
----- Original Message -----
To: Multiple recipients of list <mailto:ODTUG-SQLPLUS-L@fatcity.com> ODTUG-SQLPLUS-L \
Sent: Thursday, December 30, 2004 3:18 PM
Hi All,
From which table or view can I get the latest SCN # of the database ? Please advise.
Thanking you in anticipation.
Regards
Kamal
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1476" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff size=2>Dear
Mr Paul,</FONT></SPAN></DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff size=2>Thanks
for your advise.. In fact I was looking for a DBa related list only but could
not find it. I am trying to subscribe that.</FONT></SPAN></DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff size=2>Thank
you very much for your advise.</FONT></SPAN></DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff
size=2>Regards</FONT></SPAN></DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff size=2>Kamal
Mutneja</FONT></SPAN></DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=145031012-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> ml-errors@fatcity.com
[mailto:ml-errors@fatcity.com]<B>On Behalf Of </B>Paul Dorsey<BR><B>Sent:</B>
Thursday, December 30, 2004 5:28 PM<BR><B>To:</B> Multiple recipients of list
ODTUG-SQLPLUS-L<BR><B>Subject:</B> RE: from where to get the latest scn of
database <BR><BR></FONT></DIV>
<DIV><SPAN class=490245511-30122004><FONT face=Arial color=#0000ff
size=2>Kamal,</FONT></SPAN></DIV>
<DIV><SPAN class=490245511-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=490245511-30122004><FONT face=Arial color=#0000ff size=2>You
might want to join Oracle-L.</FONT></SPAN></DIV>
<DIV><SPAN class=490245511-30122004><FONT face=Arial color=#0000ff size=2>The
number of DBAs on this list is pretty small.</FONT></SPAN></DIV>
<DIV><SPAN class=490245511-30122004><FONT face=Arial color=#0000ff size=2>I
think you would get better, faster answers to your
questions.</FONT></SPAN></DIV>
<DIV><SPAN class=490245511-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=490245511-30122004><FONT face=Arial color=#0000ff
size=2>Paul</FONT></SPAN></DIV>
<DIV><SPAN class=490245511-30122004></SPAN> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; \
MARGIN-RIGHT: 0px"> <DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] <B>On Behalf Of
</B>Kamal Mutneja<BR><B>Sent:</B> Thursday, December 30, 2004 6:09
AM<BR><B>To:</B> Multiple recipients of list
ODTUG-SQLPLUS-L<BR><B>Subject:</B> RE: from where to get the latest scn of
database <BR><BR></FONT></DIV>
<DIV><SPAN class=177070411-30122004><FONT face=Arial color=#0000ff
size=2>Hi</FONT></SPAN></DIV>
<DIV><SPAN class=177070411-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=177070411-30122004><FONT face=Arial color=#0000ff size=2>We
can get checkpoint_change# even from v$database . I was looking for scn word
!! earlier. </FONT></SPAN></DIV>
<DIV><SPAN class=177070411-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=177070411-30122004><FONT face=Arial color=#0000ff
size=2>Thanks for help.</FONT></SPAN></DIV>
<DIV><SPAN class=177070411-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=177070411-30122004><FONT face=Arial color=#0000ff
size=2>Regards</FONT></SPAN></DIV>
<DIV><SPAN class=177070411-30122004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=177070411-30122004><FONT face=Arial color=#0000ff
size=2>Kamal</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> ml-errors@fatcity.com
[mailto:ml-errors@fatcity.com]<B>On Behalf Of </B>Deepak
Panda<BR><B>Sent:</B> Thursday, December 30, 2004 3:58 PM<BR><B>To:</B>
Multiple recipients of list ODTUG-SQLPLUS-L<BR><B>Subject:</B> Re: from
where to get the latest scn of database <BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Please use</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>select CHECKPOINT_CHANGE#,CHECKPOINT_TIME
from v$datafile;</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Hope this works for you.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Deepak</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: \
#000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">----- Original \
Message ----- </DIV> <DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> \
<A title=kamal.mutneja@india.birlasoft.com
href="mailto:kamal.mutneja@india.birlasoft.com">Kamal Mutneja</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=ODTUG-SQLPLUS-L@fatcity.com
href="mailto:ODTUG-SQLPLUS-L@fatcity.com">Multiple recipients of list
ODTUG-SQLPLUS-L</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, December 30, 2004
3:18 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> from where to get the
latest scn of database </DIV>
<DIV><BR></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Hi All,</FONT> </P>
<P><FONT face=Arial size=2>From which table or view can I get the latest
SCN # of the database ? Please advise.</FONT> </P>
<P><FONT face=Arial size=2>Thanking you in anticipation.</FONT> </P>
<P><FONT face=Arial size=2>Regards</FONT> </P>
<P><FONT face=Arial size=2>Kamal</FONT>
</P><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
Desktop 2005 - You're Virtually There! February 15-17, 2005
Visit http://www.odtug.com for details. Computer + internet required.
Keynote Speakers: Bill Inmon, Sohaib Abbasi and Thomas Kurian.
--
Author: Kamal Mutneja
INET: kamal.mutneja@india.birlasoft.com
Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic