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

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_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 Tue Aug 08 2006 - 10:38:07 CDT