Re: Large data transfer

Depending on your platform, you may not be able to use export/import. The reason is that on some platforms there is a limit to file size. There is a reasonable chance that the export will generate a file that is too large, particularly for the Unix side.

Depending on the complexity of the database, you may be better off using SQL*NET copies in SQL*PLUS rather than replication. (By complexity I mean number of tables, foreign key depencies, etc.)

The performance of replication and copying will depend highly on the network and it's traffic load.

Based on my experience and database complexity, you can probably script and excute the SQL*NET copying before you can set up replication, let alone start moving data.

In article <7l4okh$nkm$1_at_s3000-01.magna.com.au>,   "Haris Kusumo" <hkusumo_at_elixir.com.au> wrote:
> Hi,
>
> I am planning to migrate data from Unix to Novell, the data is
approximately
> about 10GB +
>
> There is daily backup happening every night.
> I think using export utility will take a long time to export 10GB+
data.
> Can you tell me how fast is to transfer data using replication ?
>
> Can you tell me what is the best and quickest way to transfer the data
> accross, please.
>
> I appreciated if you could e-mail me the reply to
hkusumo_at_elixir.com.au
>
> Thank you in advance
>
> - Haris -
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.