Try checking the default storage parameters for the tablespaces in which
the tables are located.

Aryeh Keefe

-----Original Message-----
From: Patricia Phung
[mailto:oracledba-ezmlmshield-x98358488.[Email address protected]
Sent: Wednesday, June 30, 2004 7:32 AM
To: LazyDBA Discussion
Subject: RE: Table size inconsistency

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



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