Re: How to create the seed database?

Peter wrote:

> On Mon, 06 Oct 2003 20:49:57 +1000, "Howard J. Rogers"
> <hjr_at_dizwell.com> wrote:
>
> I could not find a windows service named "OracleServiceHR" so I don't
> think I have the seed database HR installed.
> Even if I use DBCA to create a new database named HR, it is not the
> same as the seed database HR that Oracle would have created during
> installation.
> But, is there a way to install the seed database using the Oracle
> Installer or whatever without reinstalling Oracle?
>
> Thanks.
>

Peter, try and read the entire post.

Also try and understand that 'HR' is NOT a database, but a user within a database, who happens to have some tables containing employment-related data.

I didn't ask you whether you had an 'OracleServiceHR', but whether you had an 'OracleServicexxxx', where 'xxxx' might be anything. Do you have such a service or not? Because it is quite possible that you have something called 'OracleServiceORCL', and yet within the database represented by that service, you'll have a user HR, with an employees table. Users, schemas and databases are not, in Oracle, what they might be in other RDBMSes with which you might be familiar.

Even if you use DBCA to create a new database named HR, it can and will very definitely be exactly the same database as Oracle would have created during installation. During installation, you get asked whether you want an OLTP, Warehouse or General database... those are exactly the same templates that DBCA uses. So that answers your last question.

But the other point is: who cares if the database is not exactly the same as you would have got during installation? Provided you've got *a* database, with some sample data in it, what more do you want?

So: simple questions requiring simple answers.

1. Do you have an 'OracleServicexxxx' of any sort?
2. Have you run dbca to create one?
3. Why not?

Regards
HJR Received on Tue Oct 07 2003 - 17:52:58 CDT