| migration(urgent) [message #71119] |
Wed, 11 September 2002 00:58  |
saravanan
Messages: 70
Registered: October 2000
|
Member |
|
|
Dear sir/madam
I have 5 dump files in oracle 7.0..how to migrate from oracle 7.o to Oracle 9i.
plz give give me the steps
yours sincerley
S.Saravanan
|
|
|
|
| Re: migration(urgent) [message #71120 is a reply to message #71119] |
Wed, 11 September 2002 02:55  |
sunil bhola
Messages: 58
Registered: July 2002
|
Member |
|
|
you can't directly import the data from the oracle 7 to oracle 9. first you have to import the data into the oracle 8i version and then import to oracle 9i version.
to exp the data
exp sunil/sunil@sunil buffer=100000 file=sunilfulldatabase.dmp consistent=y grants=y indexes=y full=y
to import the data
imp sunil/sunil@sunil buffer=1000000 file=sunilfulldatabase.dmp ignore=y full=y
Hope you got your answer
Thanks
Keep in touch
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
