Re: copy data from one datafile to another?

On Jul 4, 11:16 am, nodge <nodge.trott..._at_googlemail.com> wrote:
> 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 Received on Wed Jul 04 2007 - 12:53:39 CDT