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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 05 Aug 2006 16:12:15 +0200
Message-ID: <ul99d2hfcv5sqadk03k4rildj2sdqonfot@4ax.com> 





On 5 Aug 2006 05:31:16 -0700, "aman.oracle.dba"
<aman.oracle.dba_at_gmail.com> wrote:



>I have nearly 20 billion records in table. Now I have to transfer data

>to another database without IMP/EXP.




set up a database link to the other database
and use create table as select 


or sql*plus copy.


The requirement to exclude exp/imp is utterly silly as exp/imp
supports transportable tablespaces.



--
Sybrand Bakker, Senior Oracle DBA


Received on Sat Aug 05 2006 - 09:12:15 CDT












Original text of this message













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