Peter,
I think more information is needed to make any suggestion.
For instance, you are limited by a 1m WAN link.
What's not mentioned is the time frame for the move.
Is this a production system?
Is there a short time limit on the downtime allowed
for switching to the new system?
40 Gig over a 1 Meg link will take 91 hours at optimal
efficiency, so count on it taking twice that long, which
is about 8 days.
You can see where timing comes into play.
Will it be the same version of Oracle?
Are there any LONG columns in the data?
You need to duplicate this environment to come
up with an optimal solution, as it will take some
testing.
Jared
On Wed, 2004-02-18 at 20:50, Peter.McLarty@(protected):
> Content-Type: text/plain; charset="US-ASCII"
> Hi
>
> I have a database on one system AIX 4.3 and moving to a Solaris 9 server
> databases are separated by a 1Mb WAN link
>
> Database is physically around 40GB don't know what is the actual data but
> would be pretty close to the 40GB
>
> What would be the best way to migrate this data
>
> Options
> sqlloader
> export import
> db link
>
>
> All ideas taken into consideration
>
> Cheers
>
>
>
> --
> =================================================
> Peter McLarty E-mail: Peter.Mclarty@(protected)
> Technical Consultant WWW: http://www.mincom.com
> APAC Technical Services Phone: +61 (0)7 3303 3461
> Brisbane, Australia Mobile: +61 (0)402 094 238
> Facsimile: +61 (0)7 3303 3048
> =================================================
> "Whatever you can do or dream you can, begin it.
> Boldness has genius, power and magic in it, begin it now."
> Goethe 1749 -1832
> =================================================
> Mincom "The People, The Experience, The Vision"
>
> =================================================
>
> This transmission is for the intended addressee only and is confidential
> information. If you have received this transmission in error, please
> delete it and notify the sender. The contents of this e-mail are the
> opinion of the writer only and are not endorsed by the Mincom Group of
> companies unless expressly stated otherwise.
>
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
