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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

t538449 - 28 Apr 2006 17:58 GMT

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

Reply to this Message

Brian Peasland - 28 Apr 2006 20:00 GMT

> Hi,
>
[quoted text clipped - 7 lines]
> Thanks,
> Kenneth

While not a Windows solution...you can run exp/imp across the network to
the database. So create a TNS entry on your Solaris server pointing to
the Windows server. Then invoke imp using the TNS entry similar to the
following:

imp userid=system@tns_alias ....

You'll be able to import into the database running on Windows that way
and leverage the named pipes in Unix.

HTH,
Brian

Signature

===================================================================

Brian Peasland
oracle_dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.

"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Reply to this Message

Mladen Gogala - 30 Apr 2006 05:42 GMT

> Hi,
>
[quoted text clipped - 7 lines]
> 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

Copyright (c) 1982, 2005, Oracle. All rights reserved.

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!

Signature

http://www.mgogala.com

Reply to this Message