They are the same in both tables (blank), in fact I imported the structure of the table, this table did not exist in the target database, the interesting thing is that when I query for pct_free and pct_used I get blanks?
SQL> select pct_free, pct_used from dba_tables
where table_name = 'QUOTE'; 2

PCT_FREE PCT_USED
---------- ----------



-----Original Message-----
From: Gowda Kempe (ETW)
[mailto:oracledba-ezmlmshield-x31963797.[Email address protected]
Sent: Tuesday, June 29, 2004 9:12 PM
To: LazyDBA Discussion
Subject: RE: Table size inconsistency


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





--------
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