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

Oracle 9.2.0.1 DB solaris 8 To Oracle 10.2.0.5  AIX 6.1

924717 Newbie
Currently Being Moderated
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

Legend

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