RE: Moving schema from 10g on Windows to 10g AIX 5L?
- From: "Pete Sharman" <peter.sharman@xxxxxxxxxx>
- To: "brian.peasey@xxxxxxxxx" <brian.peasey@xxxxxxxxx>, Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 Oct 2005 02:21:20 +1000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
