Re: export/import compress?

In article <3ig5ou$fgs_at_instasrv.admin>, ccisaac_at_mtu.edu (Chuck Isaacson) writes:
.
.
> The process was as follows:
> 1 multiple exports as system for each owner rows=y indexes=y separate .dmp
> (default is compress=y)
> 2 export as system full=y rows=n (default is compress=y)
> 3 create new instance
> 4 import as system full=y rows=n - to recreate all tables
> 5 multiple imports as system for each of the owners rows=y indexes=y using
> the separate .dmp files from step 1
>
> Step 1 was run with more than 1 export executing at a time
> Step 5 was run with more than 1 import executing at a time
>
> Oracle level 6.0.37
>
> There were more than 1500 tables involved so this is a small percentage
> but I am confused as to why export did not compress all tables. Can
> anyone provide an explanation?
>

The reason for your obsevation is that you did not export the rows. Set rows=Y and your extents would be compressed.

This is a known 'feature' or bug, whichever way you want to look at it.

ta
tony  

-- 
 _____       ________ / ___ |Tony Jambu, Database Consultant
  /_  _        /_ __ /      |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_(  |CIS: 100250.2003_at_compuserve.com FAX: +61-3-2536173
 \_______/                  |Email:TJambu_at_wizard.com.au PHONE: +61-3-2536385