cannot exp more than 2 G (urgent)

[puneet]

Hi

I cannot export more than 2 Gb File . It gives an error while in teh OS there are files of sizes 10 Gb also

what do I do

version is 8.0.6

regards

[marist89]

Take a look at:
[url]http://osi.oracle.com/wa/ask/owa/ask_tom_pkg.display?p_dispid=32412348052[/url]

[omegamark]

There is a filesize option set filesize=2048m and
files =a.dmp,b.dmp,c.dmp ect
if a.dmp becomes 2048m(2GB)it will start exporting to b.dmp like taht.

When importing just specify all the dumpfiles and add filesize parameter also.simple and easy.

[sysdba]

I do not think Oracle 8.0.6 supports filesize.

[rschulze]

Maybe this can help you, doubt it thoug
:

Creating a compressed export file
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
% mknod /tmp/exp_pipe p # Make the pipe
% compress < /tmp/exp_pipe > export.dmp.Z & # Background compress % exp file=exp_pipe <other options> # Export to the pipe

Reading a compressed export file
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
% mknod /tmp/imp_pipe p # Make the pipe
% uncompress < export.dmp.Z > /tmp/imp_pipe & # Background uncompress % imp file=imp_pipe <other options> # Import from the pipe

[aracnid]

If you have problems with the file (2g) , have to use the fifo file:
so on unix: mkfifo fifo_file_name
then
exp parfile..path../YOUR_PAR_FILE.par &
compress <..path../FIFO_FILE_NAME >..path../YOUR_EXPORT_FILE.Z
your exp file now is compresed (and can be > 2g)


but for import you have to use the same way...(by fifo)
imp parfile=..path../YOUR_PAR_FILE.par &
uncompress </..path../YOUR_EXPORT_FILE.Z>..path../FIFO_FILE_NAME



Ps. What is the right synthax for writing exp with the filesize parameter?

[Prof]

But if compress dump larger where 2G? Maybe I can use row device?

[rsuri]

what is your OS ?
Just a couple of weeks ago I exported one database creating a dump file of 8GB on Oracle 7.3.2 running on NT 4.0

What is the exact error you are getting ?

- Rajeev

[puneet]

Thanks Guys


The problem is ssolved . I had to use a script using mknod and then compressing teh file . It works and thanks you guys for your support .