Re: How do I create Datafiles?

elwood_at_rumba.m.isar.de (Konstantinos Agouros) wrote:

>Hi,
 

>my question might be stupid, but how do I create new Datafiles.
>I need that in order to create a new tablespace. Hints welcome.

Actually, you have it turned around 180 degrees. Creating the tablespace results in the datafile being created.

Create tablespace my_space datafile
'/usr/home/oracle/tables/my_space.dbf01' size 500M;

or to add space to an existing tablespace

alter tablespace my_space add datafile
'/usr/home/oracle/tables/my_space.dbf02' size 200M;

etc...

Mike

>Konstantin
>--
>Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood_at_rumba.m.isar.de
>Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
>----------------------------------------------------------------------------
>"Treason, like beauty, lies in the eye of the beholder." Garak
Received on Sun Apr 14 1996 - 00:00:00 CEST