Re: Oracle8 datafiles setting

From: Niall Litchfield <niall.litchfield_at_doial.pipex.com>
Date: 2000/07/21
Message-ID: <8l9paq$rtv$1@soap.pipex.net>#1/1

there is a one to many relationship between an Oracle tablespace and its datafiles. it therefore follows that you need to look at

create tablespace X

and

alter tablespace X.

This is all documented in the Oracle documentation.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Ken" <shihlo_at_erols.com> wrote in message
news:39732C11.B2CBB0CD_at_erols.com...


> I confused the oracle datafile setting:

>

> create database datafile...

> create tablespace .... datafile ....

> alter database create datafile....

> alter database datafile....

> alter tablespace ... add datafile ....

>

> which commands are used when the datafile is not exist and need to

> create?

> which commands are used when the datafile is already exist ?

>

> Ken

>

>

Received on Fri Jul 21 2000 - 00:00:00 CDT