| Export / Import: 8.0.5 to 8i/9i [message #55406] |
Thu, 23 January 2003 03:21  |
Sascha
Messages: 15
Registered: November 2002
|
Junior Member |
|
|
Hello!
I have an old system with 8.0.5 database, and 1 Schema that is the productive User. All applications need this 1 User.
I would upgrade to 8i or 9i.
The best way to do this I think is Export/Import? What do you mean.
Can I do an export with exp30-8.0.5. and import with exp from 8i or 9i?
Is this the best and fastest way?
Regards
Sascha
|
|
|
|
|
|
| Thank you - but can I do also... [message #55409 is a reply to message #55407] |
Thu, 23 January 2003 04:10  |
Sascha
Messages: 15
Registered: November 2002
|
Junior Member |
|
|
as I described above.
->
Install a new 8i Database on another machine, create the same user as in 8.0.5 and then import the dump file that I have generated with exp30 under 8.0.5.?
I think this is the fastest way?
Does it work?
Regards
Sascha
|
|
|
|
|
|
|
|
|
|
| Re: Export / Import: 8.0.5 to 8i/9i [message #55417 is a reply to message #55406] |
Thu, 23 January 2003 08:34 |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
Doing and export and then an import is fine for this case (from 805 to 8i or 9i). Just the upgrade with the u008xxxx.sql script is not possible.
Catch is, you need to use the same version of export (8.0.5) and import (8.0.5). You cannot export in 8.0.5 (exp version 8.0.5) and import in 9.2.0 (imp version 9.2.0) or vice versa.
Here is what you need to do.
1. Create a new database in your desired version (8i or 9i). Say 9.2.0
2. Create the same user with all roles and tablespace.
Now you have 2 choices
3A. Export the schema. Note version of exp. say 8.0.5
4A. Import in the new DB with the same version of imp, which is 8.0.5.
or
3B. Export the schema with exp version 9.2.0
4B. Import in the new DB with the same version of imp, which is 9.2.0.
Good Luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
