| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Here we go again...OCP
--=_ORCL_5887998_0r0
Content-Type:text/plain; charset="iso-8859-1"
Content-Transfer-Encoding:quoted-printable
I did go get my certification and while I think that its really just a way for Oracle to get money (and to compete with Microsoft certifications) I don't think its a complete waste of time. I am fairly experienced but at the same time I was forced to learn some things that I just never had to do. I had read about them but never tried them out. As well, since most of my experience had been with Oracle7 I was forced to learn the new features of Oracle8 before I had to work with it. And when I decide to go upgrade to 8i OCP I will be forced to learn those new features that I am not currently forced to know. As long as one does not just read and actually gets a practice database to play with it could be beneficial but nothing bets real life experience.
kimberly.smith_at_eds.com
--=_ORCL_5887998_0r0
content-type:message/rfc822
Date: 27 Apr 2000 19:10:53
From:Lisa_Koivu_at_gelco.com
To:Multiple recipients of list ORACLE-L <ORACLE-L>
Subject:Here we go again...OCP
Reply-to:UNIX.IOGMD:ORACLE-L_at_fatcity.com
Return-Path:root_at_fatcity.cts.com
Received:from gmd.fujitsu.com (ducks.gmd.fujitsu.com [198.6.119.2]) by hdoc02.gmd.fujitsu.com with SMTP (8.7.1/8.7.1) id FAA11466 for <ksmith1.ofcmail_at_hdbi01>; Fri, 28 Apr 2000 05:56:26 -0700 (PDT) Received:from dfwl01.gmd.fujitsu.com by gmd.fujitsu.com (SMI-8.6/) id FAA28256; Fri, 28 Apr 2000 05:56:20 -0700 Received:from dfwl01.gmd.fujitsu.com (root_at_localhost) by dfwl01.gmd.fujitsu.com with ESMTP id FAA14811 for <ksmith1_at_gmd.fujitsu.com>; Fri, 28 Apr 2000 05:56:20 -0700 (PDT) Received:from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199]) by dfwl01.gmd.fujitsu.com with ESMTP id FAA14807 for <ksmith1_at_gmd.fujitsu.com>; Fri, 28 Apr 2000 05:56:19 -0700 (PDT) Received:from fatcity.UUCP (uucp_at_localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA89953; Fri, 28 Apr 2000 05:56:22 -0700 (PDT) Received:by fatcity.com (02-Mar-2000/v1.0f-b68/bab) via UUCP id 00152B6F; Thu, 27 Apr 2000 18:10:53 -0800Message-ID:<F001.00152B6F.20000427181053_at_fatcity.com> X-Comment:Oracle RDBMS Community Forum
Hello all, I hate to bring up a topic that's been beaten to death but here goes.
I passed OCP exam on Backup and Recovery this morning. I feel that I
understand
the do's and dont's of restore fairly well. However I've never had to do it
in a
catastrophic situation. I do not know very much about RMAN. however I STILL
PASSED. This exam was by no means measuring my ability to restore a
completely
hosed database.
I am wondering now about what OCP is really good for then. I do not have a
bachelor's degree so I want to complete OCP anyway. It will make job
hunting in
Florida with less than one year experience as a DBA a bit easier. Does
anyone
else feel that this certification is worthless?
Thanks
Lisa
-- Author: INET: Lisa_Koivu_at_gelco.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). --=_ORCL_5887998_0r0-- ------------------------------ From: "Adams, Matthew (GEA, 088130)" <MATT.ADAMS_at_APPL.GE.COM> Date: Fri, 28 Apr 2000 11:04:14 -0400 Subject: RE: sql-plus variable error? I apologize for typing too fast. This was not meant for the whole list, just Terry.Received on Fri Apr 28 2000 - 10:00:38 CDT
> -----Original Message-----
> From: Adams, Matthew (GEA, 088130)
> Sent: Friday, April 28, 2000 11:03 AM
> To: 'ORACLE-L_at_fatcity.com'
> Subject: RE: sql-plus variable error?
>
>
> Terry,
>
> Anyone from CSG going to be at IOUG-A conference
> week after next?
>
> Matt Adams
> (CSG Transplanted ex-dba)
>
> > -----Original Message-----
> > From: Terry Ball [mailto:terry_ball_at_csgsystems.com]
> > Sent: Friday, April 28, 2000 9:19 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: sql-plus variable error?
> >
> >
> > Try using two dots:
> > INSERT INTO &SCHEMAOWNERTO..HpxCatalog
> >
> > Terry
> >
> > Guang Mei wrote:
> >
> > > I have the following script in a file:
> > >
> > > --
> > > set verify off
> > > set feedback off
> > >
> > > accept SCHEMAOWNERFROM char prompt 'Enter Owner of the
> > Schema you wish to
> > > move data FROM:'
> > > accept SCHEMAOWNERTO char prompt 'Enter Owner of the Schema
> > you wish to move
> > > data TO:'
> > >
> > > select 'insert into HpxCatalog:' from dual;
> > >
> > > INSERT INTO &SCHEMAOWNERTO.HpxCatalog(
> > > CatalogID,
> > > CatalogName,
> > > Description,
> > > Active )
> > > Values (
> > > &SCHEMAOWNERTO.HPXSEQ_Catalog.nextval,
> > > 'Catalog_Name1', -- hardcoded
> > > '',
> > > 'T' );
> > > --
> > >
> > > When I run this file in sql-plus, and I enter the two
> > variables (two schema
> > > names)at prompt, say 'testfrom' and 'testto', I got the
> > following error in
> > > sql-plus:
> > >
> > > 'INSERTINTOHPXCATALOG:'
> > > -----------------------
> > > insert into HpxCatalog:
> > > INSERT INTO testtoHpxCatalog(
> > > *
> > > ERROR at line 1:
> > > ORA-00942: table or view does not exist
> > >
> > > I thought I would get "INSERT INTO testto.HpxCatalog("
> > stuff with a dot "."
> > > in it. Any idea what I did wrong?
> > >
> > > Thanks.
> > >
> > > Guang
> > >
> > ______________________________________________________________
> > __________
> > > Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
> >
> > --
> > Author: Guang Mei
> > INET: zlmei_at_hotmail.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).
>
> --
> Author: Terry Ball
> INET: terry_ball_at_csgsystems.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).
>
------------------------------ From: "Adams, Matthew (GEA, 088130)" <MATT.ADAMS_at_APPL.GE.COM>
 |
 |