Re: Change default directory for the new extents

Couldn't you create a datafile in a seperate drive/directory, then add it to the tablespace in question?

In article <729194$33m$1_at_sunrise.pg.gda.pl>, Piotr Kolodziej <pkol_at_otago.gda.pl> wrote:

>Extents are allocated in existing files. So there's no
>way to change their directory except of moving datafiles.
>
>HTH,
>Piotr Kolodziej
>pkol_at_otago.gda.pl
>

>Adam Rudzik wrote in message <364761D1.FAEFBBF3_at_vela.ca>...
>>Could someone tell me if there is a way to change
>>the default directory for the physical files when
>>new extents will be created. The disk where we
>>keep Oracle data files is almost full and we would
>>like to create data files on another (new) harddrive.
>>We are running Oracle 7.3.3 on NT box.
>>Thanks in advance.

--

Joe Brown                    -               Programmer
joebrown_at_leading.net         -                      DBA
joe@.hopi.dtcc.edu           -            Network Admin
http://users.leading.net/~joebrown     Have a Great day!!!