Very Computer

Hi All,

Is it possible to create a new database using Personal Oracle 7. If
possible, we would like to create a new database and deploy it with our
application. How many databases can Personal Oracle 7 handle? If it can
not handle more than one database, is it possible to trash the "Local
database" and create a new database.

If it is possible to create new database, Please let me know how to
create new database and deploy it. Is there any documentation specific
to Personal Oracle 7 that says anything about creating a new database
using Personal Oracle 7.

Thanks,
Ganga

was heard to utter:

Quote:>If it is possible to create new database, Please let me know how to
>create new database and deploy it. Is there any documentation specific
>to Personal Oracle 7 that says anything about creating a new database
>using Personal Oracle 7.

Drop me a line if you have any specific questions.

-- Tracy Nelson (tnelson/voicenet.com)

Can you run twon instances same time?

---Lou

Quote:

> You can create new databases with PO7.  I wrote a script that created
> a new database and tablespaces, then ran it from SQL*DBA.  The easiest
> thing to do is to modify the BUILD_DB.SQL script that comes with PO7.

> Drop me a line if you have any specific questions.

> -- Tracy Nelson (tnelson/voicenet.com)

The short answer is yes.

try something like:

svrmrg>  drop database <databse_name>
svrmgr>  create database etc....

If you've running on Win95 (not sure about NT) and didn't install a starter
database you'll need to create a password file before you can successfully
start Server Manager. You can do this with the ORAPWD7x utility - there's a
tiny section on this in the on-line help.
--
Nick Ashley - ait

To reply via e-mail remove spam-off from the above address.