Re: Simple Import Question
- From: J.Velikanovs@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 19 Jul 2004 13:20:52 +0300
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@xxxxxxxx
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
19.07.2004 13:12
Please respond to oracle-l
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
19.07.2004 13:20
Please respond to oracle-l
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
