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: Maxim Demenko <mdemenko_at_arcor.de>
Date: Tue, 08 Aug 2006 17:46:13 +0200
Message-ID: <44d8b363$0$6989$9b4e6d93@newsspool1.arcor-online.net> 





superG schrieb:


> 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:



>> --
>> Sybrand Bakker, Senior Oracle DBA




> 




And what is the append hint in the select good for ?



Best regards



Maxim
Received on Tue Aug 08 2006 - 10:46:13 CDT












Original text of this message













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