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

Home -> Community -> Usenet -> c.d.o.server -> Re: Why I too don't like the OCP

Re: Why I too don't like the OCP

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 26 Apr 2002 21:03:18 +0100
Message-ID: <3CC9B286.5FB5@yahoo.com>


Daniel Morgan wrote:
>
> I just got done cleaning up a mess caused someone whose knowledge came
> from passing the OCP exam rather than having real experience.
>
> Thought I'd pass this along as it may help others learn the ropes.
>
> The task: Refresh data from a production database into a development
> database so developers can work with fresher data.
>
> The issue: Some table's had struture changes (we would hope so) in the
> development database so they didn't match the tables in production.
>
> The OCP's solution: Rename the existing tables in development. Export
> from production and import into development. Why rename? So the changes
> wouldn't be lost.
>
> Can you guess what went wrong?
>
> When the triggers, indexes, and named constraints from production came
> in they could not be created because objects with the same name existed
> on the tables that had been renamed.
>
> Lesson: Knowing that you can not have two objects with the same name in
> a schema (undoubtedly a test question) does not mean that you can
> anticipate the implications of your actions. Only practical experience
> teaches that.
>
> Jack

True story from lazydba.com

"What does rownum mean?

   Signed xxx
   OCP 7,8,8i"

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Fri Apr 26 2002 - 15:03:18 CDT

Original text of this message

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