Solved

uncompress and gunzip

Posted on 2007-11-26
4
1,031 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I wrote an article (http://www.experts-exchange.com/articles/2245/Anti-rootkit-software.html) some time ago with a reference to nLite  (http://www.nliteos.com/)slipstreaming software.  I recently changed that link to point to NTLite (https://www.ntl…
I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now