Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Simple Import Question

Re: Simple Import Question

From: zhu chao <zhuchao_at_gmail.com>
Date: Mon, 19 Jul 2004 17:08:14 +0800
Message-ID: <962cf44b040719020879f38151@mail.gmail.com>


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.

On Mon, 19 Jul 2004 12:14:49 +0500, fahd mirza <fahd-m_at_aero.com.pk> wrote:
> Dear Listers,
> I want to import a huge table in my database with nologging. what would be the syntax?
> thanks
> regards,
> Fahd
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_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
> -----------------------------------------------------------------
>

-- 
Regards
Zhu Chao
www.cnoug.org
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_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
-----------------------------------------------------------------
Received on Mon Jul 19 2004 - 04:04:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US