Re: Large data transfer

For transfer of a data base from unix to unix I used the pipe (export-pipe-import). No file - no file size limit. The transfer of 15GB DB has taken me 12 hours.

mpir_at_compuserve.com wrote:

> 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.
Received on Mon Jun 28 1999 - 00:00:00 CEST