-
problem in uncompressing
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 .
-
yu can pipe the file through uncompress and straight into the import program ... search the forum for "uncompress export pipe", or something like that
-
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
Last edited by prakashs43; 03-04-2004 at 12:57 PM.
-
looks good to me..
Thanks,
Thanigaivasan
-
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.
Sanjay G.
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..
Thanks,
Thanigaivasan.
-
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 .
-
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)
-
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
-
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
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|