| upgrade 8i to 9i [message #61284] |
Mon, 12 April 2004 01:50  |
AB
Messages: 41
Registered: July 2002
|
Member |
|
|
Hi,
I’ ve 8i oracle database running on NT 4.0 We setup Win2000 server and 8i to 9i oracle database will be run on. I have to convert all 8i data to 9i database How I can do it this process except exp and IMP method.
Thanks for ur help in advance .
|
|
|
|
| Re: upgrade 8i to 9i [message #61285 is a reply to message #61284] |
Mon, 12 April 2004 02:02  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
If u r using oracle version 8.1.7 than u can use oracle upgrade assistant to upgrade ur DB. But anyhow if u r using version less than 8.1.7 then to use upgrade assistant first u have to upgrade ur DB to the version 8.1.7 after that only u can use upgrade assistant.
Upgrade Assistant can be used in two ways i.e. manual and auto means using wizards, for more check oracle doc for same.
But y u dont want to use EXP/IMP according to me its not a bad approach to use EXP/IMP for upgradation.
Daljit Singh.
|
|
|
|
| Re: upgrade 8i to 9i [message #61315 is a reply to message #61284] |
Tue, 13 April 2004 21:58 |
Abhijit D Thorat
Messages: 2
Registered: April 2004
|
Junior Member |
|
|
Hi,
I’ ve 8i oracle database We setup Win2000 server and 8i to 9i oracle database will be run on. I have to convert all 8i data to 9i database How I can do it this process by exp and IMP method.
Thanks for ur help in advance .
|
|
|
|
| Re: upgrade 8i to 9i [message #61323 is a reply to message #61315] |
Wed, 14 April 2004 07:25 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
You can migrate from 8i to 9i either using the database upgrade assistant or export/import. If you are choosing the later method,its fairly straightforward.
- install 9i
- create a fresh 9i database with the necessary & tuned block_size,tablespaces,users,instance config
- export the 8i database using 8i exp. Make sure there are no updates to this 8i database,during the export.
- import the schemas into 9i database using 9i imp
- take care of other things like grants,public synonyms,database triggers,dbms_jobs
- perform any other post migration tasks on the new database.
If something goes wrong,you still have your 8i database to start over again.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
