-
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
-
Take a look at:
[url]http://osi.oracle.com/wa/ask/owa/ask_tom_pkg.display?p_dispid=32412348052[/url]
Jeff Hunter
-
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.
Radhakrishnan.M
-
I do not think Oracle 8.0.6 supports filesize.
-
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
-
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?
-
But if compress dump larger where 2G? Maybe I can use row device?
-
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
-
Problem Solved
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 .
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
|