Home » RDBMS Server » Server Administration » Best way to move 8.1.6 to 9i - new server
Best way to move 8.1.6 to 9i - new server [message #134824] Sat, 27 August 2005 11:43 Go to next message
stacygra
Messages: 1
Registered: August 2005
Junior Member
Hello:

What is the best way to move from 8.1.6 to 9i - I will be installing 9.2.0.6 on a new server and the server where 8.1.6 resides will be retired. Can I just export the 8.1.6 schemas and them import them into the 9i instance? What else would I need to run? Any u*.sql scripts or catpatch.sql?

Thanks.

Report message to a moderator

Re: Best way to move 8.1.6 to 9i - new server [message #134839 is a reply to message #134824] Sat, 27 August 2005 16:28 Go to previous message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member
hi,
If your database size is small then you can use the import and export utility .
export the users from your old server and mport them into the new server.
c:\>exp system/manager file=xxx.dmp owner=username (On old server)
c:\>imp system/manager file=xxx.dmp fromuser=olduse touser=newuser (On new server)
Export and Import all the users this way.

Regards.

Report message to a moderator

Previous Topic: QUOTA value -1
Next Topic: Database is not opening
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 11:30:12 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.