OraFAQ Forum: Server Utilities » using 8i dump to import into 9i

Home » RDBMS Server » Server Utilities » using 8i dump to import into 9i (9i, Win XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

using 8i dump to import into 9i [message #338541]

Tue, 05 August 2008 05:36

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

Report message to a moderator

Re: using 8i dump to import into 9i [message #338543 is a reply to message #338541]

Tue, 05 August 2008 05:38

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: using 8i dump to import into 9i [message #338614 is a reply to message #338543]

Tue, 05 August 2008 08:01

Littlefoot
Messages: 21809
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.

Report message to a moderator

Re: using 8i dump to import into 9i [message #338620 is a reply to message #338614]

Tue, 05 August 2008 08:33

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

Report message to a moderator

Re: using 8i dump to import into 9i [message #338629 is a reply to message #338620]

Tue, 05 August 2008 09:00

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.

Report message to a moderator

Re: using 8i dump to import into 9i [message #338673 is a reply to message #338629]

Tue, 05 August 2008 10:54

durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere

Senior Member

yes it did, thanks

Report message to a moderator

Previous Topic:	Creating Physical table by using External tables
Next Topic:	Reconcillation of data loaded thro sqlloader to remote server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 22:58:33 CDT 2024