1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

oracle 10g R2 running with archivelog mode and imp big schema

Discussion in 'General' started by pinchaschaim, Jun 17, 2011.

  1. pinchaschaim

    pinchaschaim Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    I'm backing again with one new question.

    I need to import (imp command) one schema with a lot of very big tables to one Oracle instance that is running with archivelog mode. I don't have any problems to switich this instance to archivelog to noarchivelog.

    I would like to do the following steps: 1 - change the instance to noarchivelog
    2 - execute the imp command
    3 - change the instance to archivelog again

    Can I do this? This is make sense? Can you comment this, please.


    Tks,

    Pini :hurray
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Sounds fine to me.
     
  3. zunnun

    zunnun Guest

    there no issue it's possible