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
|
|
|
|