Calculating 8i Row Size

[timofe]

Does anyone know how to calculate the size of a database row consisting of only NUMBER, DATE and VARCHAR2 columns in 8.1.7?

There used to be a formula for 8, does it still apply (and, if so, can anyone remember what it is)?

 

[alexhu]

Admin Guide Release 8.0 Appendix A; Space Estimations for Schema Objects

Can't find the same in 8i though

Alex

 

[timofe]

Alex,

Thanks, but I've already looked there.

Why do Oracle do you a favour in one release and then take it away in the next release?! Frustrating is not the word...

Cheers,

Tim

 

[JamesGordon]

There is a vsize function you can use i.e. (from the top of my head):
select vsize(col_varchar2), vsize(col_number) ...
from table;

Try searching for vsize in the docs.

 

[timofe]

Sorry. Maybe I didn't make myself clear.

I'm trying to predict the size before any data is loaded.

Will vsize work in this case?

Thanks for your assistance.

 

[JamesGordon]

Well, numbers and dates are fixed lenght and you could take a maxinum possible on the varchar2?