problem in uncompressing

[prakashs43]

Hi ,

We have filesystem of 3096000 KB . and my compressed export dump is 1771997 KB . now when i try to uncompress my file filesystem is getting filled up and not uncompressing the export dump . could anybody tell me if there is work around to uncompress the export dump .

also could you suggest if I could ftp compressed file from unix to windows and uncompress that and ftp this back .

appreciate your quick response .

[slimdave]

yu can pipe the file through uncompress and straight into the import program ... search the forum for "uncompress export pipe", or something like that

[prakashs43]

Slimdave ,

Thanks .... but , does this uncompress before doing the import .. ??
will the performance become slow while importing from compressed
file.

How can i test this script without importing to the database ?? I think we can do this using file == in imp par file .

am i missing anything .

#!/bin/ksh
rm -r /tmp/imp_pipe
mknod /tmp/imp_pipe
uncompress < FullExport.dmp.Z > /tmp/imp_pipe & sleep 3 $ORACLE_HOME/bin/imp file=/tmp/imp_pipe parfile=import.par

[thanigai]

looks good to me..
Thanks,
Thanigaivasan

[SANJAY_G]

Originally posted by prakashs43

How can i test this script without importing to the database ?? I think we can do this using file == in imp par file

SHOW=Y. It will not import any data.

[thanigai]

Please ref Oracle Database Handbook it explains with examples..
Thanks,
Thanigaivasan.

[prakashs43]

Hi ,

Now we have added new disks successfully but when i try to uncompress the export dump this is failing filesize too large .

could you suggest how to fix that .

i suspect it has filesize limitation set in solaris .
how can i check this .

[DaPi]

I'm no UNIX guy, but you might have 2GB limit on file size.
If so, you will have to limit filesize in the export:

FILESIZE=1GB
FILE=(file1, file2, file3, file4)

[prakashs43]

i checked if there is any filesize limitation using ulimit -a command
. but as per my interpretation there is no such limitation

P-Oracle /export/home/oracle >ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 256
vmemory(kbytes) unlimited

[Mr.Hanky]

As Dave said, you can use a pipe and it will not uncompress the file.
Do you have space on the mount point?

bdf.

MH