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

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 08 Aug 2006 09:17:19 -0700
Message-ID: <1155053840.563027@bubbleator.drizzle.com>

Maxim Demenko wrote:
> 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

Performance.

-- 
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 Tue Aug 08 2006 - 11:17:19 CDT