DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Export Import Urgent

  1. #11
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    You have an export file from 8.1.6 and you want to import into 8.1.5 then:

    1. Create a new entry in your 8.1.6 tnsnames server for the 8.1.5 database.
    2. Try to connect to this 8.1.5 from the 8.1.6 server using this new description connection.
    3. In the 8.1.6 server execute the import utility using a user with permissions in your 8.1.5 database and using the new entry of the tnsnames for 8.1.5 database.

    With this your are doing the import with the import 8.1.6 utility into the 8.1.5 database through the network as a sqlplus connection.

    Do you understand now?

  2. #12
    Join Date
    Sep 2000
    Posts
    305
    yes I understood but agian I have one problem is that because the server i.e 8.1.6 is on net and server 8.1.5 is my local server which is not on net now tell me is it possible to do?

    thanks

  3. #13
    Join Date
    Jan 2002
    Posts
    3
    Hi,

    I think Shailendra what aarroyob trying to say is when you import using @(db_name of 8.1.5 server). It will import the data into 8.1.5 server not in 8.1.6 server. The only thing you are using here is import utility of 8.1.6. Correct me if I am wrong aarroyob.

    Thanks
    TK

  4. #14
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Yes, you only need to open a session in the 8.1.6 server:

    If it is Unix via telnet or something similar
    If it is NT take remote control with some tool

    Regards

    Angel

  5. #15
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    I'm not sure but probably you can to execute the catexp catalog 8.1.6 into your 8.1.5 server, do the import using the import utility 8.1.5 and then run catexp 8.1.5.

    Could anybody confirm this?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width