RE: Moving schema from 10g on Windows to 10g AIX 5L?

Look into cross platform transportable tablespaces. In 10g it may well be the fastest way to move data between two different OS's (though at 30 gig, you're not moving huge amounts and expdp/impdp via a network pipe may be comparable - never tested it to see).  

Pete  

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook  

"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BP Sent: Thursday, 6 October 2005 12:10 AM
To: Oracle-L
Subject: Moving schema from 10g on Windows to 10g AIX 5L?

Hi,

I don't have much experience yet as a DBA and need some advice. We have an Oracle 10g instance running on Windows machine and may need to move particular schema to a new AIX 5L machine; also running 10g.

In the past (as a developer) I would use the import/export utilities to move copy/move schema's, but only between Windows machines. Is this possible between two different platforms? The current datafiles total about 30gigs.

Any other suggested solutions are also appreciated and I would be happy to research, learn & test them.

Thx Much,
Brian Peasey

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l