>> Hey guys,
>>
>> second problem today:
>>
>> is it possible to remove some datafiles from a tablespace and put this
>> data back into the remaining datafiles? All datafiles are there for the
>> same tablespace. Is there a simple command to do this?
>>
>> I've got a big tablespace with more then 40 datafiles - each file is
>> 400MB. Therer are 4 file which I want to be removed. It's a RAW
>> Filesystem and these 4 Files were created on the real file system by
>> accident.
>>
>> Thx
>> Nodge

> > Hi Nodge,> > If I understand you correctly, you have about 36 datafiles on 36 raw> devices, all of which belong to a given tablespace. You added four> datafiles to the tablespace, each of which were erroneously created on a> filesystem. You want to move the data from the four datafiles into the> remaining 36 datafiles, and then drop those four datafiles you created> on the filesystem.> > I'm afraid this isn't possible. If you have four additional raw devices> available large enough to hold the current size of the datafiles, you> can use rman copy, or even dd if you are Unix/Linux, to copy/recover> from the filesystem them when they are offline on to the raw devices.> > HTH,> > Steve

Very simple. You can either do export import or you can dd the files to
the raw devices of the corresponding size and rename the files.