Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OCP - Oracle 8i New Features Exam
Hi Hamdi,
SQL> select object_type from dba_objects where object_name = 'V$PARAMETER';
OBJECT_TYPE
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
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