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

Aman,

   Take a few minutes and look at Transportable Tablespaces.

Subject: Getting Started with Transportable Tablespaces Note:100693.1

...Pete

aman.oracle.dba wrote:
> 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 - 12:59:48 CDT