Re: OCP - Oracle 8i New Features Exam
Date: Tue, 03 Apr 2001 06:48:11 +0200
Message-ID: <3AC9560B.935E816F_at_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 Tue Apr 03 2001 - 06:48:11 CEST