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!

exp and imp between two distincts instance

Discussion in 'General' started by pinchaschaim, Nov 3, 2010.

  1. pinchaschaim

    pinchaschaim Active Member

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

    I need to export all objects of one schema of one instance to other instance. The instances are oracle 10g 10.2 on unix environment.

    So can I get the sintax to do these oracle command, imp and exp?

    Thanks a lot,

    Pini
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Please read here:

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#SUTIL001

    and here:

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2150

    There is plenty of documentation on exp and imp available.