Home » RDBMS Server » Server Utilities » using 8i dump to import into 9i (9i, Win XP)
using 8i dump to import into 9i [message #338541] Tue, 05 August 2008 05:36 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

If I use 8i dump and import it into 9i would and if all the objects are imported properly would it run properly or should I be taking any additional steps

Re: using 8i dump to import into 9i [message #338543 is a reply to message #338541] Tue, 05 August 2008 05:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If you do it all right, it will just work good. Any additional steps, whatever they are depends on your schema options.
Re: using 8i dump to import into 9i [message #338614 is a reply to message #338543] Tue, 05 August 2008 08:01 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just to remind you that the first "proper" step is to use 8i Export utility and 9i Import utility.
Re: using 8i dump to import into 9i [message #338620 is a reply to message #338614] Tue, 05 August 2008 08:33 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
if you mean this one then that is exactly what I did or is there any other way to do it (except restore ofcourse)

imp userid/pwd file= fromuser= touser=....
Re: using 8i dump to import into 9i [message #338629 is a reply to message #338620] Tue, 05 August 2008 09:00 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

If import operation end with the following lines then don't do anything else.

Import terminated successfully without warnings.

Re: using 8i dump to import into 9i [message #338673 is a reply to message #338629] Tue, 05 August 2008 10:54 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
yes it did, thanks
Previous Topic: Creating Physical table by using External tables
Next Topic: Reconcillation of data loaded thro sqlloader to remote server
Goto Forum:
  


Current Time: Fri Dec 02 12:09:13 CST 2016

Total time taken to generate the page: 0.08274 seconds