Full DB export from 9i to 10g
637022Nov 17 2008 — edited Nov 17 2008Hello everybody,
I am trying to do a full export from a oracle 9i database running in solaris and import it to a 10g database running in solaris platform.
I have done the full export of the database with full=y, rows=n statistics=none. my requirement is just to export and import the structure of the existing database to the new one.
i have pre created the tablespaces in the new database where i am suppose to import but when i executed the imp command with full=y ignore=y its gives me lots of errors. the message is get at the end of import is:
Import Terminated successfully with warnings and when i check the log i have lots of Imp-0003,ora-30371,Imp-00017. when i checked the 10g database the users are imported but the objects are not. can some body help.
Thanks.