This discussion is archived
3 Replies Latest reply: Nov 24, 2012 7:44 AM by Srini Chavali-Oracle RSS

importing from 10g to 11 g database.

888412 Newbie
Currently Being Moderated
We are migrating 10g oracle db on solaris to 11g on linux and we are using normal exp and imp.

We have taken export dump using exp full=y option as we require public synonyms and db links on 10g database
And now we are trying to import around 50 schmeas from that dump on 11g database.
my question is
1)can we use imp full=y option as we require public synonyms and db links and also same time we need to import only 50 schmeas from that dump
2)need to recreate tablespaces and users on target databse?
3)will other default schemas override if we give full=y option while import.

Thanks,

Edited by: 885409 on Nov 24, 2012 4:16 AM

Legend

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