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:29:38 -0700
Message-ID: <1154975371.773704@bubbleator.drizzle.com>

Pete wrote:

> 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

>

Pete please don't top post.

And given no version number how do you know he has the capability. If Aman is not willing to provide the required information making recommendations is just shooting in the dark.

But it is a nice shot given that we know know we are talking about different databases on different servers with the same o/s.

-- 
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:29:38 CDT