OraFAQ Forum: Server Utilities » exp compatibility with lower verison of Oracle database

Home » RDBMS Server » Server Utilities » exp compatibility with lower verison of Oracle database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exp compatibility with lower verison of Oracle database [message #161101]

Thu, 02 March 2006 00:52

glaszlo
Messages: 1
Registered: March 2006
Location: romania

Junior Member

Hi all,

I have an 8.0.5 Oracle database on Linux, and I want to make a dump but the exp utility cannot write bigger files then 2G. Can i use exp utility from an 8.1.7 Oracle database Linux to make this export? It is ok to copy exp from one to other install?

Thank You

Report message to a moderator

Re: exp compatibility with lower verison of Oracle database [message #161261 is a reply to message #161101]

Thu, 02 March 2006 20:42

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Using the 8.0.5 version, make the target of your export a named pipe rather than a regular file. Then have a background process that either cats or zips the file.

eg.

/etc/mkfifo expdat.dmp
cat expdat.dmp  > saved.dmp &
exp userid/pwd ...

/etc/mkfifo expdat.dmp
compress < expdat.dmp > expdat.dmp.Z &
exp userid/pwd ...

You should find that both cat and compress handle 64 bit file lengths. Many years ago, gzip was 32 bit - but has probably been fixed by now.
_____________
Ross Leishman

Report message to a moderator

Previous Topic:	import issue
Next Topic:	structure of table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 10 22:14:58 CDT 2026