Oracle Table Size Issue

[BadBoy23]

Bayyaaa !!!!

select sum(bytes/1024/1024/1024) from dba_segments where segment_name='table_name';

[color=#ff0000]3.4287109375[/color]

but when exporting

userid=''
directory=''
TABLES=EDW.REMEDY_DISPATCH_LOG_DIM
dumpfile=REMEDY_DISPATCH_LOG_DIM.dmp
logfile=REMEDY_DISPATCH_LOG_DIM.log
parallel=4
cluster=y


> expdp parfile=sccan.par

Export: Release 11.2.0.3.0 - Production on Wed Jul 17 15:34:58 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLE_01": /******** AS SYSDBA parfile=sccan.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: [color=#ff0000]68.50 GB[/color]


Actual ga table size entha ???

[distinct]

[BadBoy23]

lttt

[Bondu_Babu]

Correct gaa ne Chusava

select sum(bytes/1024/1024/1024) from dba_segments where segment_name='table_name' segment_type='TABLE';

[BadBoy23]

yep

[Bondu_Babu]

[quote name='BadBoy23' timestamp='1374092901' post='1303967089']
yep
[/quote]okasari SQL query and result as it copy paste chey ikkada

[Bondu_Babu]

[quote name='BadBoy23' timestamp='1374092901' post='1303967089']
yep
[/quote]okasari SQL query and result as it copy paste chey ikkada

[BadBoy23]

SQL> select sum(bytes/1024/1024/1024) from dba_segments where segment_name='REMEDY_DISPATCH_LOG_DIM';

SUM(BYTES/1024/1024/1024)
-------------------------
3.42871094

[Gachibowli_Diwakar]

indexes on that table size chusava ?
also i suspect this table must have had either blob/lob/clob data-type column in it .. so get the size of that as well

[peru_edaite_enti]

[quote name='Silence..Please' timestamp='1374095735' post='1303967274']
indexes on that table size chusava ?
also i suspect this table must have had either blob/lob/clob data-type column in it .. so get the size of that as well
[/quote]

How to get that

[Gachibowli_Diwakar]

[quote name='CBZ' timestamp='1374096129' post='1303967295']
How to get that
[/quote] you can get lob name from dba_lobs
get size of it by querying segment_type='LOBSEGMENT' from dba_segments

[BadBoy23]

ok

[BadBoy23]

Got it thank you !!!!

it has clob datatype for one of the column also found the lob size now it matches.