Re: Oracle8 datafiles setting
From: Niall Litchfield <niall.litchfield_at_doial.pipex.com>
Date: 2000/07/21
Message-ID: <8l9paq$rtv$1_at_soap.pipex.net>#1/1
Date: 2000/07/21
Message-ID: <8l9paq$rtv$1_at_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...Received on Fri Jul 21 2000 - 00:00:00 CEST
> 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
>
>