Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fast utility to transfer data from one database to another excluding IMP/EXP
Another database on another machine but same OS.
DA Morgan wrote:
> 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 Mon Aug 07 2006 - 09:44:48 CDT