Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Simple Import Question
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of fahd mirza
Sent: Monday, July 19, 2004 5:20 AM
To: oracle-l_at_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" <zhuchao_at_gmail.com>
To: <oracle-l_at_freelists.org>
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.
-- 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_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 - 09:01:09 CDT
![]() |
![]() |