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

10g replaced export/import with DataPump. Although I've never used it myself, yet, your suppose to be able to data pump data from one database into another without the need for a dump file.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BP Sent: Wednesday, October 05, 2005 10: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 Received on Wed Oct 05 2005 - 09:18:06 CDT