Re: how to create a new database in PO7 ?

Mark Mose <mosem_at_perth.DIALix.oz.au> writes:  

>Could someone please tell me how to create a new
>database in personal Oracle 7.
>Following the on-line manual is of no help because
>when you get to step 6 "start up the instance dialog
>box of SQL*DBA" you are snookered, THERE ISN'T ONE !!
 

If you follow the hot-link to page 3-5, you get to a picture of the Startup Instance Dialog box. You will see it looks like a character-mode form.  

However, if you keep reading, the next section is labelled "The STARTUP Command". On Windows, we need to stick to the commands, it seems.  

I did some poking around in File Manager, and found the command files used by the installation program to build the "starter" database. You probably can just copy and modify these.  

See the \ORAWIN\DBS directory for BUILDALL.SQL This, in turn, calls many other scripts, such as BUILD_DB.SQL, which performs the STARTUP command as its first step.  

Also see the \ORAWIN\RDBMS71 directory for the INIT.ORA parameter file called by the STARTUP command.  

See the \ORAWIN\RDBMS71\ADMIN directory for many *.SQL scripts called by the BUILD*.SQL files.  

• Rick --

(Rick Rutt is a system architect living and working in Midland, Michigan.) Received on Thu Apr 27 1995 - 00:00:00 CEST