How to create a new local database with PO7?

Hi, everyone,

        I have downloaded the Personal Oracle 7 and tried it for serveral weeks, with its sample database with no problem. So, I want to create a new database locally for test. I used the SQL*DBA to connect as "internal", then startup an instance with the parameters "nomount", and also "pfile" to identify another parameter file, which is the same as init.ora except changed DB_NAME to "TEST" and CONTROL_FILE to ctl2.ora.

After all these done, I entered the following statement:

sql>CREATE DATABASE TEST
  2>LOGFILE GROUP 1 ('TSTLOG1A.LOG', 'TSTLOG1B.LOG') SIZE 500K,         GROUP 2 ('TSTLOG2A.LOG', 'TSTLOG2B.LOG') SIZE 500K   3>DATAFILE 'TSTSYS.DAT' SIZE 6M; And then, what should I do to create users? I am new on using ORACLE, please give me some guidences.

Any of your response is appreciated.

Best regards.
--Andy. Received on Tue Jul 04 1995 - 00:00:00 CEST