Default table size?

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
siva sankar
Posts: 130
Joined: Sun Mar 11, 2007 1:47 am
Location: India

Default table size?

Post 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...
kareem2003
Posts: 40
Joined: Tue Jun 12, 2007 11:25 am
Location: India
Contact:

Post by kareem2003 »

hi,
we know that DUAL one default table
DUAL default varchar2
so it has size is one varchar2(one charater)
bye
amirtai
Posts: 138
Joined: Sat Apr 08, 2006 5:54 pm
Location: Canada
Contact:

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

Who is online

Users browsing this forum: No registered users and 4 guests