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

From: Acme Acmeson <nahdsl232734_at_nahvip.cybercity.dk>
Date: Tue, 8 Aug 2006 20:15:47 +0200
Message-ID: <44d8d4ca$0$67262$157c6196@dreader2.cybercity.dk>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1155053840.563027_at_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

When inserting rows the append hint may have an impact, but also when selecting ?
Didn't know that. Are you sure ?
Regards
Keld Nielsen Received on Tue Aug 08 2006 - 13:15:47 CDT