| dan |
Posted: May 15, 2008 11:09:55 AM |
Total Post: 17
Joined: May, 2008
|
Hi Experts,
In Exp/Utility,
why we use the parameter compress?
|
|
|
 Virusminus |
| Posted: May 15, 2008 11:29:37 AM |  |
|
Total Post: 15
Joined: Jan, 2008
|
As the word says compress, we use it for compressing the data which we are exporting, with this option the dump file obtained occupies lesser space comparatively.
compress=Y
|
|
|
|
|
| dan |
| Posted: May 15, 2008 11:35:58 AM | |
|
Total Post: 17
Joined: May, 2008
|
This question has been asked me in an interview many a times.
|
|
|
|
|
| Gitesh |
| Posted: May 15, 2008 11:14:49 PM | |
|
Total Post: 322
Joined: May, 2005
|
Compress=Y means Oracle will make single extent instead of all extents. Oracle merges all extents of table segment in to one large extent.
When we are trying to remove fragmentation of table segment that time this export utility use with compress=Y. Default value of this parameter is also "Y".
|
|
|
|
|
| Murtuja |
| Posted: May 16, 2008 12:45:22 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
compress=Y will make a single extent and it will change DDL of table/index only. This option can't compress dump file.
For compressing dump file we have to use utilities like gzip.
compress has one drawback also.If during import object doesn't found contiguous space in datafile then import will fail. so be careful while using compress=Y
|
|
|
|
|
| dan |
| Posted: May 16, 2008 04:58:36 AM | |
|
Total Post: 17
Joined: May, 2008
|
Thanks for clearing doubts...
In which we can use this parameter.
|
|
|
|
|
| dan |
| Posted: May 16, 2008 05:58:23 AM | |
|
Total Post: 17
Joined: May, 2008
|
I mean to say in whcih case we can use this parameter.
|
|
|
|
|
| Gitesh |
| Posted: May 16, 2008 11:44:59 PM | |
|
Total Post: 322
Joined: May, 2005
|
Check my reply....For removing fragmentation of segment.
|
|
|
|
|
| dan |
| Posted: May 19, 2008 07:57:17 AM | |
|
Total Post: 17
Joined: May, 2008
|
Hi ALL,
thank you very much for clearing my doubts ...
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
