iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Oracle 11g New Features

Online Oracle Training

 

How to compress/uncompress Oracle exported dump file on UNIX/LINUX

 

 

Steps to compress and export an oracle database
1-Make a compress pipe file
# mknod /tmp/compresspipe p

2-Compress the file using compress pipe file
# compress   -c   </tmp/compresspipe   >xx &

-- xx is: /your-export-location/your-export.dmp

3-Now, you can export your database
# exp system/password  full=y file=/tmp/compresspipe


Steps to uncompress and import to an oracle database
1-Make a compress pipe file
# mknod /tmp/compresspipe p

2-Uncompress the file using compress pipe file
# uncompress   -c   </xx   >/tmp/compresspipe  &

3-Now, you can import to your database
# imp system/your-password  full=n fromuser=  touser= file=/tmp/compresspipe

 

 

Good Luck!

 

Google
 
Web web site