Re: Creating a **DEFAULT** database

Hi Mshetty (are you really that sharp :)

Couple of points.

If you need to recreate your database everytime it crashes, you may want to consider how will it's protected and how good your recovery skills are. The simple solution to your problem would be to perform an appropriate database recovery.

With regard to creating a new "default" database, use the Database Configuration Assistant and the custom option will create a "default" database for you. This is the easiest way for those new to Oracle.

With respect to the number of default databases, you can create as many databases as you wish (resources permitting). Each database is uniquely identified with an ORACLE_SID value (which you select when creating the database).

Go ahead and create a new database but this time look after it :)

Good Luck

Richard

"mshetty" <mshetty_at_mail.com> wrote in message news:bfbb8fd4.0207251750.dd9af2b_at_posting.google.com...
> Hi,
>
> Can I create a **default** database after Oracle is installed ?? We
> are using Oracle 8.1.5 on HP-UX, that was installed some time back. It
> looks like the default database created while installing has crashed
> for some reason. We now need to create a default database. Can this be
> done ?? How many default databases can we have ??
>
> Would help if I could get some help on the above.
>
> Thanks and Regards,
> M Shetty
>
> PS: We don't seem to have any kind of documentation except for a book
> on Oracle.
Received on Thu Jul 25 2002 - 23:50:06 CDT