problem in uncompressing
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 .
yu can pipe the file through uncompress and straight into the import program ... search the forum for "uncompress export pipe", or something like that
Thanks .... but , does this uncompress before doing the import .. ??
will the performance become slow while importing from compressed
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 .
rm -r /tmp/imp_pipe
uncompress < FullExport.dmp.Z > /tmp/imp_pipe & sleep 3 $ORACLE_HOME/bin/imp file=/tmp/imp_pipe parfile=import.par
Last edited by prakashs43; 03-04-2004 at 11:57 AM.
looks good to me..
SHOW=Y. It will not import any data.
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
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Please ref Oracle Database Handbook it explains with examples..
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 .
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:
FILE=(file1, file2, file3, file4)
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
As Dave said, you can use a pipe and it will not uncompress the file.
Do you have space on the mount point?
I remember when this place was cool.
Click Here to Expand Forum to Full Width