Importing data into 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Importing data into 9i

  1. #1
    Join Date
    Jan 2003
    Posts
    38

    Importing data into 9i

    Hello,

    I need to export data in a 10g database and then import it in a 9i database. I read some docs online that said, in order to do so I need to use exp utility from 9i to export data on 10g and then only I can import that data in 9i.

    I wanted to know if there is any particular procedure to follow to use oracle 9i's export utility on 10g or I just need to copy the exp binary from the 9i db machine to the 10g db machine and use it

    Thanks a lot
    -K

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    done need to copy exp at all (won't work if you do that)

    Just use exp from the 9i client and set up the 10g database in your tnsnames.ora file

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