Oracle Data Pump in 10g allows you to do this . . . =20 I have done some thing similar using old school Oracle Copy=20 (http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/apb .htm#634246 ) there are restrictions and watch out for RI and constraints. We are testing it out now to ReOrg an old 8i database. =20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Paula_Stankus@xxxxxxxxxxxxxxx Sent: Friday, May 21, 2004 7:15 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: exporting directly from one server to another Guys, I am upgrading an 8.0.6 database to 9i with an export/import. It is a =3D 24x7 high input system. I remember coming across a method a long long = =3D time ago that allowed you to export through a pipe directly to another = =3D box as being fast as heck. Was I dreaming this? Thanks, Paula ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------