OraFAQ Forum: Server Administration » Cross platform and Oracle version migration

Home » RDBMS Server » Server Administration » Cross platform and Oracle version migration

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

Cross platform and Oracle version migration [message #148499]

Thu, 24 November 2005 12:27

watchadoin
Messages: 2
Registered: November 2005

Junior Member

Hi All,
We have HP-UX, Oracle 8.1.7.4 database, size of around 60GB and very little free disk space.
We also have a new IBM Wintel box where I intend to install Oracle 9.2.0.3.

I would like to do a full export from our current Unix setup and import to the Wintel machine but as we don't have sufficient disk space on the Unix machine, I wondered if we could run the export from the Unix machine and use the Wintel box to store the .dmp files?
We have SAMBA installed on our Unix machine (but not configured properly) so can anyone offer any thoughts as to achieving the cross platform export?

Thanks,

Jet

Report message to a moderator

Re: Cross platform and Oracle version migration [message #148539 is a reply to message #148499]

Thu, 24 November 2005 19:08

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

Senior Member
Account Moderator

>>We have SAMBA installed on our Unix machine (but not configured properly)

If this is unix related problem, please talk to your System Admin or post in an unix forum ( samba related issues).
Your options are
Run export from unix machine, write to a samba share (as you proposed)
or
Install Oracle 8.1.7.4 client in any machine.
Using this client export your unix database to any windows share you want.
Use the same version of imp.exe (8.1.7.4) to import into your new 9i database
or
Install 9i in your new IBM machine.
using 9i exp.exe export your 8i database in unix and write to a local drive in windows machine.
using 9i imp.exe import into your 9i database.
But to do this , you need to run $ORACLE_HOME_9I/rdbms/admin/catexp.sql) against the 8i database logged in as sys ( You are installing the views related to 9i in and 8i database).
or
use the combination of database links and good old CTAS (create table as select).
install 9i in new machine.
export only the structure of 8i database (not the data. So you need very minimal space).
Recreate tablespaces/users in 9i (make use of exported dump or do
it manually).
From 8i database create database links to talk to 9i database or vice versa.
Then all you need to do is
-- from 8i database issue this.
-- similarly do for all tables.
-- YOu can generate a script to do all this.
-- Recreate indexes seperately (or precreate the table using dumps with no data and just to the insert now).
sql> create table scott.emp@9idatabase as select * from scott.emp;

Report message to a moderator

Re: Cross platform and Oracle version migration [message #148665 is a reply to message #148539]

Sat, 26 November 2005 01:33

watchadoin
Messages: 2
Registered: November 2005

Junior Member

Thanks for the expected suggestions.

I suppose the solution really is to get either SAMBA woking properly (no SA unfortunately!) or maybe I'll try MS SFU.

Thanks again,

!

Report message to a moderator

Previous Topic:	Database hangs during the night ......
Next Topic:	ORA-00205 error, when installing oracle10g on linux

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 17:00:59 CST 2025