Thread: EXP
-
What is the maximum size for a export dump file.
I am using Oracle 8.1.7 on Windows NT.
Thanks
-
its OS dependent.If your doing a export and you dont have sufficient space obiviously your export will stop.So its OS dependent.From oracle view point i guess there is not limit set.
cheese
anandkl
anandkl
-
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
I do'nt thing 2GB is the limit as the size of my current export file is more than 4GB.
-
export file can be of more then 2GB but while importing this generally gives problem.
but any way if u want to export any such table , and you donot have sufficient space , u can use following trick to export in compress file.
unix prompt> mknod /tmp/exportfile p
unix prompt> compress < /tmp/exportfile > final.z &
define export file name in ur parfile ( say parmfile) as /tmp/exportfile
now
exp parfile=parmfile .........
yeah!!!
-
OS dependent but generally...
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
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
|