Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

changing database to noarchivelog mode during impdp

user11979518Jun 1 2011 — edited Jun 8 2011
Hi Guys,

I am using Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production on RHEL5.

I am in the middle on the impdp and I want my database to run on noarchivelog as it creates a lot of archivelogs.

Will it be proper if I stop the import:

e.g Import> STOP_JOB=IMMEDIATE


and shutdown the database put the database on noarchivelog mode.

then opne database and
impdp hr/hr@mydb ATTACH=myfulljob
Will these work fine?

Or should I execute:

alter system archive log stop;

Please Help !!!!!!!!!!!
This post has been answered by CKPT on Jun 1 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2011
Added on Jun 1 2011
8 comments
1,461 views