Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Fast utility to transfer data from one database to another excluding IMP/EXP

Re: Fast utility to transfer data from one database to another excluding IMP/EXP

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 06 Aug 2006 10:17:26 -0700
Message-ID: <1154884646.365255@bubbleator.drizzle.com>


aman.oracle.dba wrote:
> I have nearly 20 billion records in table. Now I have to transfer data
> to another database without IMP/EXP.

20 billion records and no Oracle version number.

20 billion records in how many tables?

20 billion records equaling how many bytes?

Another database on the same or another operating system?

And not that I'd choose IMP/EXP but why can't you use it?

I don't see how anyone can make a recommendation given the lack of information.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Aug 06 2006 - 12:17:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US