Printable View
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
looks good to me..
Thanks,
Thanigaivasan
SHOW=Y. It will not import any data.Quote:
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
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
this weekend we have added new disk with 8 GB space . and my compressed export dump through pipe is 1.8GB . i moved export dump to new filesystem /u10 and tried to uncompress and it failed . filesize too large .
1) how can i uncompress existing file .
2) How can i check filesize limit .
3) is there anything i need to check ( vizz whethere filesystem is mounted with large files .... etc )
uncompress through a pipe and import. It's the exact reverse of exporting through a pipe :rolleyes:
I tried that . It works fine .
but as a strategy to make future exports .
what should i need to change in solaris
to maintaining single export dump .
i am sure in few days even compressed export
dump will cross 2 GB . i may face problem of 2 GB there too .
I just tried export and it failed at 2GB
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully
Quote:
Originally posted by prakashs43
I tried that . It works fine .
but as a strategy to make future exports .
what should i need to change in solaris
to maintaining single export dump .
i am sure in few days even compressed export
dump will cross 2 GB . i may face problem of 2 GB there too .
I just tried export and it failed at 2GB
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully
Either enable large files, or split the .DMP files to different mount points. Although the latter can get sloppy.
Parfile Ex...
Userid=yo_moma/yo_moma
file=/yo/moma/sews/socks/that/smell/my_big_arse_1.dmp
file=/yo/moma/smells/really/bad/my_big_arse_2.dmp
FILESIZE=1800M
full=y
Si?
could anybody tell the command to enable large files
i am using solaris 5.8
Machine hardware: sun4u
OS version: 5.8
Processor type: sparc
Hardware: SUNW,Ultra-80
VxFS format .
I spoke to Elroy my system admin he said that.Quote:
Originally posted by prakashs43
could anybody tell the command to enable large files
i am using solaris 5.8
Machine hardware: sun4u
OS version: 5.8
Processor type: sparc
Hardware: SUNW,Ultra-80
VxFS format .
/eep op ork ah ah
Will do it.
;)
MH
that's fine
we don't have sysadmin .
so i thought if we can do this on fly ..
thank you all for your help .
for the benefit of all DBA's
please find the command to enable large files
To enable largefile system support:
# /usr/lib/fs/vxfs/fsadm -o largefiles /
Example: # /usr/lib/fs/vxfs/fsadm -o largefiles /u12
To verify that the largefiles flag is enabled:
# /usr/lib/fs/vxfs/fsadm /
Example: # /usr/lib/fs/vxfs/fsadm /u12