3 Replies Latest reply: Oct 4, 2012 9:00 AM by Srini Chavali-Oracle RSS

    Oracle 9.2.0.1 DB solaris 8 To Oracle 10.2.0.5  AIX 6.1

    user3469420
      Dear All,


      My Oracle 9201 database on sun 5.8 migration to 10.2.0.5 on AIX 6.1

      Step 1

      Source on Oracle 9201 database on sun 5.8 I exported the database

      exp system/**** FULL=y FILE=exp_full.dmp STATISTICS=NONE LOG=exp_full.log

      Q1 Is this command is correct or do i need to add any other parameters ?


      Step 2

      Target on AIX 6.1

      1) Installer 10g patch set etc and created the database using dbca
      2) Created all the tables spaces same as Source database

      Q1
      To Import the database using this command or do i need to some
      imp system/***** FULL=y FILE=exp_full.dmp LOG=imp_full.log IGNORE=y

      Do I need to create all the users and or What else i need do before i need to run imp

      Pls List of the things which i need to create before i run imp


      Best Regards