Re: Deleting Datafile

You can export the objects in the tablespace, drop the tablespace, re-create the tablespace, and then import the objects back into the database.

"Andrew Simkovsky" <asimkov_at_bellsouth.net> wrote in message news:<C_NN7.20730$S93.795762_at_e3500-atl2.usenetserver.com>...
> You will have to create a new tablespace, move all the objects, and drop the
> old tablespace.
>
> Andrew Simkovsky
> SYSOP, RevealNet Pipelines
>
> "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 Fri Nov 30 2001 - 20:22:51 CET