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

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 07 Aug 2006 11:28:05 -0700
Message-ID: <1154975279.165421@bubbleator.drizzle.com>

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

And the Oracle version number is?

Are both databases the same version?

You are the one asking for help. I am trying to help you. Please don't make me have to pull each and every relevant fact out of you. I asked a number of questions and they ALL must be answered to address the issue.

-- 
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 - 13:28:05 CDT