8 Replies Latest reply: Apr 10, 2012 4:14 PM by AAG RSS

    migration from 10g to 11g using datapump

    927318
      hello
      i need to migrate oracle database from 10 g to 11g to new linux server using data pump but i have few questions in mind.

      first i need to take expdp full=y of oracle 10 databse in existing server machine to any directory

      do i need to copy that dump file and log file to any directory in new server before i do import operation???

      if yes how to copy that dumpfile to new server???

      to do impdp do i need to create a new user to perform operation?

      steps

      1 impdp user/pass full=y directory =test_dir logfile=exp.log dumpfile=exp.dmp
      2 copy dump file to new server
      3 create database in new server with same tablespaces as source database
      4 impdp user/pass full=y directory =test_dir logfile=exp.log dumpfile=exp.dmp

      are these steps correct??????

      thanks
      gagan