From oracle-l-bounce@freelists.org Mon Jul 19 09:01:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6JE0hk16394 for ; Mon, 19 Jul 2004 09:00:53 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6JE0X616347 for ; Mon, 19 Jul 2004 09:00:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 216FE72C04B; Mon, 19 Jul 2004 08:40:10 -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 08834-14; Mon, 19 Jul 2004 08:40:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7115972C037; Mon, 19 Jul 2004 08:40:09 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 19 Jul 2004 08:38:47 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B78972C047 for ; Mon, 19 Jul 2004 08:38:46 -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 08187-11 for ; Mon, 19 Jul 2004 08:38:46 -0500 (EST) Received: from mail1.affina.com (mail1.affina.com [12.20.72.19]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3A74072C037 for ; Mon, 19 Jul 2004 08:38:46 -0500 (EST) Received: from apollo.affina.net (Not Verified[172.16.158.25]) by mail1.affina.com with MAIL Service, Version: 6.0 id ; Mon, 19 Jul 2004 09:04:27 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: Simple Import Question Date: Mon, 19 Jul 2004 09:04:27 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Simple Import Question Thread-Index: AcRteVYBK2tp+L+rTHyBEpM7IsOGpgAH7p4w From: "Chris Stephens" To: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5403 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ChrisStephens@Affina.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Import it into a database with in no archive mode...create a link...insert /*+ append */ blah....nologging; (drop indexes prior) ...create indexes nologging. Viola...except now your recovery is messed up in case of a failure. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of fahd mirza Sent: Monday, July 19, 2004 5:20 AM To: oracle-l@freelists.org Subject: Re: Simple Import Question Come on guys, please find me a way. because , the thing is that due to some reasons I have turned the automatic archival off, while my database(8.1.6) is running in archive mode. So when I try to import a huge schema with huge tables (which has to be done , because it belongs to a very senior developer), I have to manaully archive the redo files again and again and again...., so please save my fingers and tell me how could I import this huge schema with nologging. thanks regards, Fahd ----- Original Message ----- From: "zhu chao" To: Sent: Monday, July 19, 2004 2:08 PM Subject: Re: Simple Import Question > I'm afraid IMP cannot be done in nologging mode. > > However, you can drop the index, import without index and later create > index in parallel/nologging. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------