Re: DBA course scripts

On Sat, 20 Nov 2004 08:45:04 +1100, "Howard J. Rogers" <hjr_at_dizwell.com> wrote:

>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.

Well, that's more or less what I've been trying to do until now. Just trying to save some time having those scripts at hand. But anyways, thanks for the help.

Roberto Received on Mon Nov 29 2004 - 13:02:40 CST