RE: export a windows database from linux

Jeffrey,  

I believe this should not be a problem, but you should of course test it out.  

Another thing that you could use if you go down this route is to export the data into a 'pipe' file rather than a normal file while simultaneously using this 'pipe' file as the input file for your import process, so you don't have to wait until the export is complete before you start the import.  

And I assume this is a 11i database in which case, you will have to follow Metalink Note:230627.1 9i Export/Import Process for Oracle Applications Release 11i. And Tanel has a great paper out on his site http://integrid.info/ about 11i upgrade that you could apply here.

Merry Christmas!
John Kanagaraj <
DB Soft Inc
Phone: 408-970-7002 (W)  

Co-Author: Oracle Database 10g Insider Solutions http://www.samspublishing.com/title/0672327910  

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

  ---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Thursday, December 22, 2005 9:09 AM To: oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com; ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_LazyDBA.com; oracle-rdbms_at_yahoogroups.com
Subject: export a windows database from linux

Source database is 9.2.0.6 on windows. Target is 9.2.0.7 on Linux. Instead of exporting on windows, ftp'ing the dump to Linux and then running an import. Could I run export on Linux against the Windows database. This would eliminate the ftp step since going right to the linux system during the export.  

Usually want export to be same version as the database, but since both 9i, could I do this?    

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

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