This discussion is archived
3 Replies Latest reply: Oct 4, 2012 7:00 AM by Srini Chavali-Oracle RSS

Oracle DB solaris 8 To Oracle  AIX 6.1

924717 Newbie
Currently Being Moderated
Dear All,

My Oracle 9201 database on sun 5.8 migration to 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

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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points