Home » RDBMS Server » Server Utilities » exp compatibility with lower verison of Oracle database
exp compatibility with lower verison of Oracle database [message #161101] Thu, 02 March 2006 00:52 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 19:53:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.