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: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 5 Oct 2005 10:27:18 -0400
Message-ID: <001f01c5c9b8$e3f33720$bb59000a@vttaxnet.tax.state.vt.us>


You are also supposed to use rman to duplicate accross platforms. I do not have 10g so I haven't tried it either.

Regards,
Ruth

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Goulet, Dick Sent: Wednesday, October 05, 2005 10:15 AM To: brian.peasey_at_gmail.com; Oracle-L
Subject: 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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 05 2005 - 09:30:15 CDT

Original text of this message

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