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

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 08 Aug 2006 19:03:58 +0200
Message-ID: <ebag5q$vvr$02$1@news.t-online.com>

DA Morgan schrieb:

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

Interesting... until today i believed, the best way to achieve an optimal performance is to put in the init.ora fast=true

Obviously i was wrong

Best regards

Maxim Received on Tue Aug 08 2006 - 12:03:58 CDT