check ur segment storage..like pctfree and pctused.

Thanks and Regards
KG
Ph: 503 816 9343


-----Original Message-----
From: Patricia Phung
[mailto:oracledba-ezmlmshield-x29786599.[Email address protected]
Sent: Tuesday, June 29, 2004 10:05 PM
To: LazyDBA Discussion
Subject: RE: Table size inconsistency



Hello,
Could someone help me find an explanation why if I imported 3 years worth of data of a table into a different database with same init.ora parameters, and less rows (about 1/2) the sum(bytes) from that is much larger than the source table.
My newly imported table has about 18 million rows taking up 24GB and the source table has around 32 million taking up 15GB. What could be the cause?

Thanks


--------
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: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page