| Database Sizing [message #123679] |
Tue, 14 June 2005 07:20 |
omnamahsiva2004
Messages: 2
Registered: June 2005
|
Junior Member |
|
|
I want to calculate "Combined data space" which value are (Sum of all column length)
EX:
1) If Number (10,2) then
Average length of sell = (8/2+1) =5 Bytes
2) Number (10) then 10/2+1=6
3) varchar2(10) then 10
Combined data space = (1)+(2)+(3)
My question is:
What will be the values when table column contain CLOB,BLOB,BFILE data type.
Considering TEST TABLE:
create table TEST(A NUMBER(10,2),
B NUMBER(10,2),
C VARCHAR2(10),
D CLOB,
E BLOB,
F BFILE));
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
