Re: From 7.3.4 (Unix) to 10gR2 (Windows).

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sun, 30 Apr 2006 04:42:16 GMT
Message-Id: <pan.2006.04.30.04.42.14.986117@sbcglobal.net>

On Fri, 28 Apr 2006 09:58:11 -0700, t538449 wrote:

> Hi,
> 
> I have a 7.3.4 database on a Solaris 2.5 server (32 bit) I want to
> export and import into a 10gR2 database on Windows 2003 (32 bit). Since
> Solaris 2.5 and 7.3.4 has a limit on 2Gb files, I usually use pipes to
> transfer exports between servers, but I dont know how to resolve this
> with Windows 2003. Is there any way of achieving this without having to
> ugrade the 7.3.4 database?
> 
> Thanks,
> Kenneth

Yes. Do import remotely, from the Solaris side, or export into the pipe and compress the output, and then copy it by using scp or sftp to Windows server. What I have in mind is something like this:

$ cd /tmp
$ mknod expdat.dmp p
$ dd if=expdat.dmp|gzip|dd of=/tmp/scott.dmp.gz &
[1]     5796

$ exp scott/tiger statistics=none

Export: Release 10.2.0.2.0 - Production on Sun Apr 30 00:35:30 2006

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table BONUS 0 rows exported
. . exporting table DBI_LOB 3 rows exported
. . exporting table DEPT 4 rows exported
. . exporting table EMP 14 rows exported
. . exporting table EMP1 14 rows exported
. . exporting table SALGRADE 5 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics

Export terminated successfully without warnings. 14160+0 records in
14160+0 records out
$ 14085+1 records in
14085+1 records out

Now, you ended up with a file named /tmp/scott.dmp.gz which can then be copied to the Windoze machine, uncompressed and imported. In addition to that, I beg you to think twice about leaving the comfortable security of Solaris and switch to a lousy excuse for an operating system called "Windows". Windows is Red Socks of the operating systems league: it sucks. Go Yanks!

-- 
http://www.mgogala.com

Received on Sat Apr 29 2006 - 23:42:16 CDT