From oracle-l-bounce@freelists.org Mon Jun 6 10:35:43 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j56FZhkh032754 for ; Mon, 6 Jun 2005 10:35:43 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j56FZhNi032750 for ; Mon, 6 Jun 2005 10:35:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F1C1A1BBB3C; Mon, 6 Jun 2005 09:32:33 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00383-05; Mon, 6 Jun 2005 09:32:33 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 523D21BBAC5; Mon, 6 Jun 2005 09:32:33 -0500 (EST) Message-ID: <42A45E12.4080100@pacbell.net> Date: Mon, 06 Jun 2005 07:30:42 -0700 From: Mark Bole User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: oracle-l@freelists.org Subject: Re: ** import tuning References: <20050606140831.74363.qmail@web60713.mail.yahoo.com> In-Reply-To: <20050606140831.74363.qmail@web60713.mail.yahoo.com> Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 20686 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: makbo@pacbell.net Precedence: normal Reply-To: makbo@pacbell.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 A Joshi wrote: > > Basically is export taken with direct option any different from regular export? "Virtual Private Database (VPD) and Oracle Label Security are not enforced during direct path Exports." (from the docs). Otherwise direct path export is faster than conventional path export, but the import side of things is unaffected by whether or not the export was direct. I use the default RECORDLENGTH for the export, and for the import, I specify COMMIT=Y and an appropriate BUFFER value. -Mark Bole -- http://www.freelists.org/webpage/oracle-l