Moving data - EXPORT or COPY or SQLLOADER ???

From: <djose_at_att.com>
Date: 1997/07/23
Message-ID: <869677767.23875@dejanews.com>#1/1

Hi everyone,

Problem :

---

Move 2 tables with > 1 million rows from one machine to another. Exports files would be > 2 gig ( unix file limit )

Alternatives I considered:

---

1. using COPY command over SQL*Net linking both machines/databases.
2. Moving subsets of data thru flat files.
3. ????

My Questions:

---

1. Can anyone who has had prior experience in the above advice on the best alternative / strategies they adopted ?

Thanks for your time.

regds,
jude

-------------------==== Posted via Deja News ====-----------------------

      http://www.dejanews.com/ Search, Read, Post to Usenet Received on Wed Jul 23 1997 - 00:00:00 CDT