Hi,

My undestanding is that if you export a segment with compress = yes, all the segment will be concatenated into one single extent, despite of the several extents that may exist in the source segment.

Sometimes this causes problems, as it is not possible to gather contigous free space in the target tablespace, to store the entire segment.

Regards,

AM


-----Original Message-----
From: Devender Narula
[mailto:oracledba-ezmlmshield-x90451025.[Email address protected]
Sent: terça-feira, 17 de Agosto de 2004 6:22
To: LazyDBA Discussion
Subject: compress parameter in export


hi guys

can anyone explain me the importance of compress parameter in export
utility . if possible with some example as things are not clear in
oracle docs.

thanks

Devender




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


------------------------------------------
This message may contain confidential information or privileged material,
and is intended only for the individual(s) named. If you are not in the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message
which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.

Vodafone (Portugal)

Oracle LazyDBA home page