Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: OCP - Oracle 8i New Features Exam

Re: OCP - Oracle 8i New Features Exam

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Tue, 03 Apr 2001 06:48:11 +0200
Message-ID: <3AC9560B.935E816F@0800-einwahl.de>

Hi Hamdi,

SQL> select object_type from dba_objects where object_name = 'V$PARAMETER';

OBJECT_TYPE



SYNONYM So you look up the synonyms by

SQL> select * from dba_synonyms where synonym_name = 'V$PARAMETER';

OWNER                          SYNONYM_NAME
------------------------------ ------------------------------
TABLE_OWNER                    TABLE_NAME
------------------------------ ------------------------------
DB_LINK
PUBLIC                         V$PARAMETER
SYS                            V_$PARAMETER

So the real object inquired is sys.v_$parameter. Now let us inquire this:

SQL> select object_type from dba_objects where object_name = 'V_$PARAMETER' and owner = 'SYS';

OBJECT_TYPE



VIEW Here you go. The real object is the view sys.v_$parameter.

Please don't crosspost.

Martin

Hamdi wrote:
>
> Hi all,
>
> I have a question regarding the Oracle8i New Features upgrade exam, I am
> certified as OCP 7.3 and did the upgrade to 8.0, so still ahead of me the 8i
> exam now, I am studing from Oracle University Course, the question is if I
> compare the exam checklist from Oracle web site it doesn't map exactly to
> the Material chapters, did anyone took that exam and knows what chapters are
> mandatory and what are optional ?
>
> Thanks guys !!
>
> please reply to hamdi.mohamed_at_sympatico.ca
>
> thanks a lot
>
> Hamdi Mohamed
> MCSE,OCP,MCP+I,ACE,CCNA
Received on Mon Apr 02 2001 - 23:48:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US