Home » RDBMS Server » Server Administration » migration of database (win2000,,9i version )
migration of database [message #575154] Sun, 20 January 2013 06:56 Go to next message
sam524
Messages: 71
Registered: July 2012
Location: sydney
Member
hi guys,

currently holding 9i database on win2000 and front end is dev4.5 so the thing is want to upgrade by win2008 pn 32bit with 10gdatabase want to keep the front end application as it is 4.5...

will it be compiatble 10g database on 32bit 2008 and front end 4.5developer forms and reports?

can i migrate 9i database to 10g database, what are the steps for full import??

thanks in advance....

Re: migration of database [message #575158 is a reply to message #575154] Sun, 20 January 2013 08:54 Go to previous message
Michel Cadot
Messages: 58856
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
can i migrate 9i database to 10g database


Yes.

Quote:
what are the steps for full import??


Precreate the tablespaces and accounts and import only the non-Oracle accounts.
If you upgrade in-place (without changing the server) then you can use dbua (database upgrade assistant).

Regards
Michel
Previous Topic: Duplicate database using dpexp and dpimp
Next Topic: tablespace size is same as before deletion of user.
Goto Forum:
  


Current Time: Thu Aug 21 19:58:07 CDT 2014

Total time taken to generate the page: 0.11829 seconds