Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nx02.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Tue, 08 Aug 2006 10:56:15 -0700 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Fast utility to transfer data from one database to another excluding IMP/EXP References: <1154781076.756804.66750@s13g2000cwa.googlegroups.com> <1155051487.594964.185240@n13g2000cwa.googlegroups.com> <44d8b363$0$6989$9b4e6d93@newsspool1.arcor-online.net> <1155053840.563027@bubbleator.drizzle.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1155059775.937402@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 34 X-Complaints-To: abuse@csolutions.net Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:272384 Maxim Demenko wrote: >>> 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 You are correct. But we try to keep that one a secret only known to the likes of Tom Kyte, Jonathan Lewis, Cary Milsap, and the other Oracle illuminati of The Oak Table. Now you've gone and told the whole world. So sad, so sad, so many unemployed DBAs. ;-) -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org