Re: How to create a new local database with PO7?

andy_at_avila.inesc.pt (Lei Chu San, Andy) wrote:

>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.

Hi Andy,

This is an extract from the script we use to create tablespaces/users. You should be able to customize it to create users in your database. Hope this helps

connect internal/oracle

create tablespace my_space datafile ‘c:\ora\dbs\wdbmy.ora’

	size 50m
	default storage (
		initial 4k
		next 4k
		pctincrease 10)
	online;

create user my_user
	identified by  user_pass
	default tablespace my_space
	quota 100m on my_space;

grant connect, resource to my_user

connect my_user/user_pass

...

Best regards
Vagif Received on Wed Jul 05 1995 - 00:00:00 CEST