Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create Database

Re: Create Database

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/12/30
Message-ID: <68b4p7$cvm$1@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US