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

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. 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