[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1050
  • Last Modified:

uncompress and gunzip

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
sharscho
Asked:
sharscho
3 Solutions
 
omarfaridCommented:
Hi,

I think it is ok since gunzip can uncompress .Z files.
0
 
robocatCommented:
gunzip can decompress files compressed with the compress command.
If you get no error messages, everything should be fine.

0
 
DavidSenior Oracle Database AdministratorCommented:
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
 
sharschoAuthor Commented:
Thank you very much!!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now