Re: How to create the seed database?

On Thu, 09 Oct 2003 06:42:30 +1000, "Howard J. Rogers" <hjr_at_dizwell.com> wrote:

>Peter wrote:
>
>
>>
>> When you ask me to read the manuals, of course, you are not telling me
>> to read the whole thing, but just the relevant parts. I usually reread
>> the parts of the manuals that I need to know.
>>
>> With regard to the definition of "instance", I was just looking it up
>> in the glossary of the manual.
>>
>> Thanks
>
>
>Why don't we try to stop this silliness right now.
>
>Peter: read what Daniel *actually* wrote, not what you think he wrote.
>Daniel said that a *SQL SERVER* instance = Oracle instance+database files.
>And as such, his definition was spot on. What you *thought* he had written
>was that "an instance" involved database files, and you naturally thought
>he was talking about an *ORACLE* instance. In which case, your definition
>would have been correct.
>

>Why Daniel thought a reference to SQL Server was needed remains a bit of a
>mystery, but it's probably because the sorts of questions you are prone to
>asking indicate some familiarity with SQL Server, and not with the quite
>different Oracle concepts and terminology.
>
>But regardless, since Daniel wasn't referring to an Oracle instance, he was
>actually correct. But who really cares... we might as well have a
>discussion about whose penis is bigger for all the difference it makes to
>resolving Oracle-related problems.
>
>Right. Now that's out of the way...
>
>What's your actual problem? And have you actually read what I wrote in an
>earlier reply, and carried it out?
>
>To summarise. If you want HR data, you will find it inside whatever database
>got created when you installed Oracle. And if you didn't create a database
>during the install, DBCA will quite happily create you such a database
>(identical to the one you *would* have got during the install) that will
>contain within it the HR schema, along with all his tables and sample data.
>You just have to ask for it on the appropriate screen of the Assistant.
>
 

I have used DBCA to create a new schema, this time using the "General Purpose" database option. After the creation I got the all the objects owned by user HR.
Do the other options create the example schemas?

Thanks Received on Thu Oct 09 2003 - 19:10:32 CDT