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 SUM(DATA_LENGTH)
------------------------------ ----------------
MYTABLE 90
It could be that the avg_row_len is less than this, but he's planning
enough storage all variable length data types to be filled.
Cheers,
g
-----Original Message-----
Sent: Tuesday, June 19, 2001 8:51 PM
To: Multiple recipients of list ORACLE-L
> 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 how large the tables are right now?
- Greg
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guy Hammond
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
