Re: Deleting Datafile
From: Andrew Simkovsky <asimkov_at_bellsouth.net>
Date: Fri, 30 Nov 2001 10:54:01 -0500
Message-ID: <C_NN7.20730$S93.795762_at_e3500-atl2.usenetserver.com>
Date: Fri, 30 Nov 2001 10:54:01 -0500
Message-ID: <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
"andrija" <ar35644_at_fer.hr> wrote in message
news:9u7ndl$e6oj$1_at_as201.hinet.hr...
SYSOP, RevealNet Pipelines
> 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 - 16:54:01 CET