Re: Deleting Datafile

hi there

fnd out all the data objects (tables, indexes) that are on tables spaces in your 'to-be deleted' data file

move them to the actual tablespace

rename the objects that are to be moved.

RE-CREATE them using their actual name these objects in your tablespace

drop the old tablespaces

do the above process for all the tablespaces, then you can get rid of your old data files

as always, kindly take a back-up before proceeding further

good luck

N.Prabhakar

andrija <ar35644_at_fer.hr> wrote in article <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 Sun Dec 02 2001 - 02:17:21 CET