Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: v$archived_log: Only 8i?
OH NO! INFORMATION OVERLOAD! 352 VIEWS! And the OCP exams will ask about HOW
many?
Guess I'm never gonna have a social life again!
Hannah:>
"Michael Ray" <Michael.Ray_at_trw.com> on 11/10/2000 01:41:25 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: Re: v$archived_log: Only 8i?
Oops! My error. I have 2 SQL*Plus sessions open and ran the query on my 8.1.5 instance, not 7.3.4. Sorry. I don't have that view in 7.3.4, only v$archive. FYI, there are 97 v$ views in 7.3.4 and 352 in 8.1.5. Yikes!
Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438
>>> Hannah.M.Doran_at_sb.com 11/10/00 12:10PM >>>
Still can't do it, but I'm on a prod box so can't re-run any scripts. But I'm in the middle of rebuilding the test and devl (devlopment) server, so as soon as its up, I'll try it there. I have 8i at home, so when I go home, I'll go play with it there too:>
Thanks,
Hannah
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Ray INET: Michael.Ray_at_trw.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).Received on Fri Nov 10 2000 - 12:52:36 CST