To calculate the storage needed for a table (assuming that all rows will contain all
of the data) use the following formula.
TO DETERMINE THE SIZE OF A TABLE STORAGE
step 1. NUMBER OF ROWS IN TABLE. ---
step 2. NUMBER OF ROWS IN BLOCK.
NUMBER
I think what he wants to do is find out how big a row could possibly be,
for example
CREATE TABLE mytable (
column1 VARCHAR2(40),
column2 VARCHAR2(30),
column3 VARCHAR2 (20));
select table_name, sum(data_length) from user_tab_columns group by
table_name;
TABLE_NAME
Dear DBA Gurus,
Assume I have an emp table under Scott Schema with the following structure.
Name Null?Type
- -
---
EMPNO NOT NULL NUMBER(4)
ENAME
I need to calculate the size of the table assuming one of the rows is
having
all the columns maxsize possible.
I don't understand your question. Do you want to plan in advance to make an
estimate of how large a table will be, or are you looking at an existing
database and wanting to find out