Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!n13g2000cwa.googlegroups.com!not-for-mail
From: "superG" <gpignatelli@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Fast utility to transfer data from one database to another excluding IMP/EXP
Date: 8 Aug 2006 08:38:07 -0700
Organization: http://groups.google.com
Lines: 24
Message-ID: <1155051487.594964.185240@n13g2000cwa.googlegroups.com>
References: <1154781076.756804.66750@s13g2000cwa.googlegroups.com>
   <ul99d2hfcv5sqadk03k4rildj2sdqonfot@4ax.com>
NNTP-Posting-Host: 217.223.201.164
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1155051492 21729 127.0.0.1 (8 Aug 2006 15:38:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 8 Aug 2006 15:38:12 +0000 (UTC)
In-Reply-To: <ul99d2hfcv5sqadk03k4rildj2sdqonfot@4ax.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; InfoPath.1),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 ics_server.dns2.interbusiness.it (ICS 2.1.134_PR1)
Complaints-To: groups-abuse@google.com
Injection-Info: n13g2000cwa.googlegroups.com; posting-host=217.223.201.164;
   posting-account=DvUdDQ0AAAAvSb596gu5rz4sZJwLM0WC
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272369

If you use CTAS, I suggest to use the following hint in SELECT:

/*+ append parallel( <table_name>, <parallelism degree>) */

Bye

G. Pignatelli
Sybrand Bakker wrote:
> On 5 Aug 2006 05:31:16 -0700, "aman.oracle.dba"
> <aman.oracle.dba@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