Home » RDBMS Server » Server Utilities » How to re-import a 9i dump file to 10g (Oracle 10g, Windows Server 2003.)
How to re-import a 9i dump file to 10g [message #458399] Sat, 29 May 2010 10:24 Go to next message
shailajasomisetty
Messages: 9
Registered: July 2005
Location: Birmingham,U.K
Junior Member
Hi,

I am in the process of upgrading our 9i DB to 10g .
As they are on different servers, I have installed 10g on the new server and applied the latest patchset 10.2.0.4.
I am creating the production database and importing th e9i dump file into this.
Now I will be testing the whole application that uses this database.
After a week, I need to take the latest 9i dump and export to the new 10g DB.
Do I need to just import the latest 9i dump into the 10g db or do I need to do anything else?

Please advise.
Shailaja
Re: How to re-import a 9i dump file to 10g [message #458405 is a reply to message #458399] Sat, 29 May 2010 10:45 Go to previous messageGo to next message
Littlefoot
Messages: 21687
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You'll probably want to remove what you already imported and - possibly - modified during the last week. If so, well, I can't tell whether there's an easy (easier) way to do it apart from dropping the (10g) database and creating it again. I guess that dropping users one after another, minding constraints etc. makes such a job tedious and unpleasant.

However, someone else might know another, better way to do that.
Re: How to re-import a 9i dump file to 10g [message #458407 is a reply to message #458399] Sat, 29 May 2010 11:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I am in the process of upgrading our 9i DB to 10g .
Please realize that on 1 July 2010 V10 will go into unsupported category.

If you upgrade to V11.2 now, the level of effort will be the same as going to V10.
Re: How to re-import a 9i dump file to 10g [message #458408 is a reply to message #458405] Sat, 29 May 2010 11:11 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Pretty much what Littlefoot said.
Generate an sql script from dba_users that will do this for all users that are concerned and import again.
drop user userName cascade constraints;
Previous Topic: EXP-00011...
Next Topic: how to load date and time from text file to oracle table through sqlloader
Goto Forum:
  


Current Time: Sun Sep 19 21:46:06 CDT 2021