Page 1 of 1

Default table size?

Posted: Mon Apr 02, 2007 10:25 pm
by siva sankar
Hi All,

I created one table,this table can store and occufying the some space.
But,my Quetion is...

What is the default table size ?

If any body knows,Please help me on this...

Posted: Thu Aug 02, 2007 8:48 am
by kareem2003
hi,
we know that DUAL one default table
DUAL default varchar2
so it has size is one varchar2(one charater)
bye

Posted: Sat Aug 04, 2007 11:38 pm
by amirtai
Hi there

u can check your any segment size in bytes with this query.

select bytes from user_segments where segment_name = '<table_name>';

Have fun.

Amir