Re: DBA course scripts

Roberto wrote:
> Hi,
>
> some time ago I made the DBA course, and I wanted to review all the
> material. I installed a copy of Oracle, but when I wanted to recreate
> the tables used in the course, the floppies with the scripts to do
> that didn't want to work. The first one (for the PL/SQL class) I still
> managed to recover. The others are goners.
>
> Does sombody know where I could get those scripts that create the
> tables for the DBA course (At the time it was for 8i)
>
> Tks,
>
> Roberto
>

They are proprietary Oracle intellectual property. What you managed to swipe on the class itself is one thing. But if you start swapping it around outside class, you're entering dangerous territory.

What you are better off doing is reading the practices in the course books and seeing what they are trying to do, and then replicating that for yourself using whatever schema data you can lay your hands on (I like scott's EMP table, but in 9i and above there's a whole bunch of sample schemas that will do useful testing duty). If you need help on creating Scott's EMP table or the other 9i schemas, just ask.

Doing it yourself will free you from the sometimes poor Oracle material. It will make you think about what's actually being asked of you in the material. It will help you think more clearly and more flexibly. And ultimately, you will know Oracle better.

Regards
HJR Received on Fri Nov 19 2004 - 15:45:04 CST