Re: Data transfer between two 8.1.6 databases

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 8 Nov 2000 00:07:41 +1100
Message-ID: <3a07fedd@news.iprimus.com.au>

Given that you are on 8.1.6, have you considered transportable tablespaces?

Brilliant idea; you simply do an o/s copy of the relavant datafiles, and 'plug them in' to the destination database by doing a quick import of the tablespaces metadata, previously prepared by doing a tablespace-level export. transportable_tablespace=y and tablespaces=(xxx, yyy,...) are the key parameters, on both sides of the equation.

It does rather depend, however, on your data in production being in discrete tablespaces which can readily be copied a datafile at a time.

Nevertheless, and that said, t beats any other method of transferring data between two databases hands down... a matter of seconds to do gigabytes of transfer (oh, and an hour of so of o/s copying beforehand).

Regards
HJR

---

Opinions expressed are my own, and not those of Oracle Corporation Oracle DBA Resources: http://www.geocities.com/howardjr2000

---

"Benoît Oury" <boury_at_absis-group.be> wrote in message news:8u8tqt$hnu$1_at_rivage.news.be.easynet.net...
>
> Hi,
>
> I've two databases, they have the same structure but not the same data
> one is a test database and one is a production database). How could I
> transfer the data from one into the other one ? Of course they do not have
> the same name...
>
> --
> __________________
> Benoit Oury
> Analyste Programmeur
> ABSIS-GROUP
> www.absis-group.be
> ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
> *** DISCLAIMER ***
>
> "This e-mail and any attachments thereto may contain information
> which is confidential and/or protected by intellectual property
> rights and are intended for the sole use of the recipient(s) named above.
> Any use of the information contained herein (including, but not limited
> to, total or partial reproduction, communication or distribution in any
> form)
> by persons other than the designated recipient(s) is prohibited.
> If you have received this e-mail in error, please notify the sender either
> by telephone or by e-mail and delete the material from any computer."
>
> Thank you for your cooperation.
>
>
>
Received on Tue Nov 07 2000 - 07:07:41 CST