Re: Deleting Datafile

Hi

If you have oracle 8.1.5 or +
you can the command :
alter table [table_name] move tablespace [new_one] and after this, you have just to rebuild the indexes in the good tablespace

hth

Chris

"andrija" <ar35644_at_fer.hr> wrote in message news:<9u7ndl$e6oj$1_at_as201.hinet.hr>...
> Before I enabled large files on filesystem, I couldn't create files larger
> than 1Gb. Now I can have larger files, but I allready have 12 files in my
> tablespace and all of them contains some data.
>
> Is there a way to move data from one datafile to another and then removing
> this empty file, or am I stuck with these 12 files forever?
Received on Mon Dec 03 2001 - 03:34:42 CET