Home » RDBMS Server » Server Administration » How to find out the maximum row size...
How to find out the maximum row size... [message #53043] Mon, 26 August 2002 11:29 Go to next message
sai
Messages: 27
Registered: October 2001
Junior Member
Hi,

would you please through some idea as to how to find out the maximum row size of an existing table in an oracle database.

Thanks in advance,
Sai

Report message to a moderator

Re: How to find out the maximum row size... [message #53048 is a reply to message #53043] Mon, 26 August 2002 13:32 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
select max(vsize(numcol1)+vsize(datecol2)+vsize(varchar2col3)+...) from my_table;

Report message to a moderator

Previous Topic: How can I set quota on TEMP tablespace.
Next Topic: Low Hit Ratio Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 10:16:51 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.