Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving schema from 10g on Windows to 10g AIX 5L?

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

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Wed, 5 Oct 2005 10:15:14 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6502D43EC2@25exch1.vicorpower.vicr.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US