Solved

uncompress and gunzip

Posted on 2007-11-26
4
1,034 Views
Last Modified: 2013-12-26
Hi experts, I did decompress a oracle export file that was compressed with the compress command on unix with gunzip. I used gunzip filename instead of uncompress filename, Will this corrupt my dump file? I need an answer before I start the import. Thank you in advance. It is a dump file made from oracle 817 on hp ux.
0
Comment
Question by:sharscho
4 Comments
 
LVL 40

Assisted Solution

by:omarfarid
omarfarid earned 125 total points
ID: 20353649
Hi,

I think it is ok since gunzip can uncompress .Z files.
0
 
LVL 21

Assisted Solution

by:robocat
robocat earned 150 total points
ID: 20353678
gunzip can decompress files compressed with the compress command.
If you get no error messages, everything should be fine.

0
 
LVL 23

Accepted Solution

by:
David earned 225 total points
ID: 20354136
I agree with the prior comments, and would add for your piece of mind:

1.  Test the compressed file integrity, e.g., "gunzip -t ...".  See man gunzip for further info.
2.  Test the dump file by executing it in test mode, using the import parameter "show=y" and specify an output log.  This will display the DDL without executing it.
3.  It's good practice to ensure your target database is recoverable prior to the change.  At a minimum, export the database with rows=n, indexes=n to grab the existing DDL.

Hope this helps.
0
 

Author Comment

by:sharscho
ID: 20354197
Thank you very much!!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question