Re: Create Database

From: Richard Wilson <onyx01_at_globalnet.co.uk>
Date: 1997/12/30
Message-ID: <01bd14bd$fbc973e0$415f7ec2@onyx>#1/1

Tao, try this to create a database instance called 'TEST' with software mirrored redo log files.

create database TEST

	maxinstances 8
	maxlogfiles 32
	maxlogmembers 4
	maxdatafiles 255
	character set "US7ASCII"

datafile '/oracle/systemTEST1.dbf' size 50M logfile

	group 1 ('/redo1/redoTEST_g1_m1.rdo',
		'/redo1/redoTEST_g1_m2.rdo') size 5M,
	group 2('/redo2/redoTEST_g2_m1.rdo'
		'/redo2/redoTEST_g2_m2.rdo') size 5M

controlfile reuse;

Good Luck!

Tao Ho <taoho_at_tdl.com> wrote in article <34A720D8.1F68_at_tdl.com>...
> I know the creating Table SQL command is "create Table",
> what about creating database SQL command ??
> Tao
>
Received on Tue Dec 30 1997 - 00:00:00 CST