Compression Parameter

You have a database of 2GB. Can you convert the database to 1GB. Which compression parameter will you use?

Questions by Pragati.rch

Showing Answers 1 - 1 of 1 Answers

hemant.agarwal03

  • Mar 18th, 2008
 

COMPRESSION =(METADATA_ONLY | NONE) - This parameter applies from Oracle 10.2. It specifies whether to compress metadata before writing to the dump file set. Compression reduces the amount of disk space consumed by dump files.

To convert from 2 GB to 1 GB it is depend of free space available in data block.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions