OraFAQ Forum: Server Administration » Migration steps 8.1.7 to 9.2.0.4?

Home » RDBMS Server » Server Administration » Migration steps 8.1.7 to 9.2.0.4?

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

Migration steps 8.1.7 to 9.2.0.4? [message #119235]

Wed, 11 May 2005 07:26

confident
Messages: 28
Registered: March 2005

Junior Member

we are going to migrate the oracle 8.1.7 on solaris to oracle 9.2.0.4 on HP-unix, our database size around 60GB... and our teamleader tell me to migrate through export option.... well iam sysadmin, can anybody give me steps of migration.....i will be very gratefull

Report message to a moderator

Re: Migration steps 8.1.7 to 9.2.0.4? [message #119247 is a reply to message #119235]

Wed, 11 May 2005 08:11

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

The best method of migrating data between Oracle databases on different platforms is export/ import. Any particular reason what they don't want to use this method?

Some of the other methods you may want to consider:

- Use the SQL*Plus COPY command
- Create a DB link and do CTAS across the DB Link
- Unload the data and use SQL*Loader to load it into the new DB

Best regards.

Frank

Report message to a moderator

Re: Migration steps 8.1.7 to 9.2.0.4? [message #119252 is a reply to message #119235]

Wed, 11 May 2005 08:21

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

Take full database export.

If posible, do create the same directory structure on the new platform as you are having on Solaris platform.

Make full database import.

After logging into Oracle as user "sys" do run the following script:

u0801070.sql. This script will be located in $ORACLE_HOME/rdbms/admin directory.

Once this execution gets over, shutdown database, take a cold backup and then start the Db again.

Regds
Girish

Report message to a moderator

Re: Migration steps 8.1.7 to 9.2.0.4? [message #119269 is a reply to message #119235]

Wed, 11 May 2005 09:18

confident
Messages: 28
Registered: March 2005

Junior Member

steps Please...?

After creating new database, i need to create only similar tablespaces and physical datafile only as like as old database, afterthat import the data, anythings else?....

Report message to a moderator

Re: Migration steps 8.1.7 to 9.2.0.4? [message #119272 is a reply to message #119269]

Wed, 11 May 2005 09:43

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Directory strucutres/tablespaces/datafiles anything can be different.
Create a new database.
Precreate the users in new databases.
assign tablespaces for users (tobe imported).
during import use FROMUSER/TOUSER clause.

>>steps Please...?

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm

Report message to a moderator

Previous Topic:	Partitioning in oracle
Next Topic:	New instance or new user ...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 03:41:29 CST 2025