Re: copy data from one datafile to another?

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Thu, 05 Jul 2007 02:40:08 GMT
Message-ID: <pan.2007.07.05.02.40.07@verizon.net>

On Wed, 04 Jul 2007 17:53:39 +0000, Steve Howard wrote:

> 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

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.

-- 
http://www.mladen-gogala.com

Received on Wed Jul 04 2007 - 21:40:08 CDT