Re: Simple Import Question

From: <J.Velikanovs_at_alise.lv>
Date: Mon, 19 Jul 2004 13:20:52 +0300
Message-ID: <OF6F1A0CB7.DE7E6F97-ONC2256ED6.0038B27A-C2256ED6.00398F53@alise.lv>

Or you can try to use _disable_logging, but be very-very careful. Investigate this before use.
http://www.google.lv/search?hl=lv&ie=UTF-8&q=_disable_logging&meta=

Jurijs
9268222

http://otn.oracle.com/ocm/jvelikanovs.html

J.Velikanovs_at_alise.lv
Sent by: oracle-l-bounce_at_freelists.org
19.07.2004 13:12
Please respond to oracle-l

        To:     oracle-l_at_freelists.org
        cc: 
        Subject:        Re: Simple Import Question


0. Make Backup
1. Shutdown database
2. Switch archivelog off
3. Startup
4. Import
5. Shutdown
6. Switch archivelog on

7. Startup
8. Make Backup
If solution not usable, then crontab archiving staff. And take care with your fingers; your future success probably depends on them ;)

Jurijs
9268222

http://otn.oracle.com/ocm/jvelikanovs.html

"fahd mirza" <fahd-m_at_aero.com.pk>
Sent by: oracle-l-bounce_at_freelists.org
19.07.2004 13:20
Please respond to oracle-l

        To:     <oracle-l_at_freelists.org>
        cc: 
        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.

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
-----------------------------------------------------------------



----------------------------------------------------------------
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
-----------------------------------------------------------------



----------------------------------------------------------------
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 - 05:25:17 CDT