In this forum you can share stuff related to Oracle 11g, 10g, 9i.
-
siva sankar
- Posts: 130
- Joined: Sun Mar 11, 2007 1:47 am
- Location: India
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
Users browsing this forum: No registered users and 0 guests