Re: Create Database

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/12/30
Message-ID: <68b4p7$cvm$1_at_news01.btx.dtag.de>#1/1


Tao Ho wrote:
>
> I know the creating Table SQL command is "create Table",
> what about creating database SQL command ??
> Tao
Hi,

its something like:

create database oracle

    logfile

		group 1 ('c:\ora_redo\wdblog1.ora',
			'f:\ora_redo\wdblog1.ora',
            		'e:\ora_redo\wdblog1.ora') size 500K reuse,
		group 2 ('c:\ora_redo\wdblog2.ora', 
			'f:\ora_redo\wdblog2.ora',
            		'e:\ora_redo\wdblog2.ora')size 500K reuse,
		group 3 ('c:\ora_redo\wdblog3.ora', 
			'f:\ora_redo\wdblog3.ora',
            		'e:\ora_redo\wdblog3.ora')size 500K reuse
    character set WE8ISO8859P1
	datafile 'd:\dbf\dbsystem.ora' size 600M reuse
	MAXLOGMEMBERS 4

;

But I think you should take a long view into the books.

-- 
Regards

Matthias Gresz    :-)
Received on Tue Dec 30 1997 - 00:00:00 CET

Original text of this message