Re: v$type_size

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: Wed, 08 Apr 1998 07:59:20 GMT
Message-ID: <352b2d0d.3896086@www.sigov.si>

On Tue, 7 Apr 1998 23:07:31 -0400, "John Wang" <rwang_at_erols.com> wrote:

>Hi, folks:
>
>there is this view called V$type_size. if you do select size from
>v$type_size, you will get an oracle error: missing expression. i cannot
>figure why it does that. size is a column in the view. why can I not
>select it?

This will work:

select "SIZE" from v$type_size;

You must put the column name (alias, as a matter of fact) SIZE in double quotes, and it must be in upper case. Can't explain the reason for this behaviour.

>The reason I use it is I need to get a formula to estimate the space for
>tables. In oracle documentation, there is a formula that does that, it is
>referencing that view. is there any script or utility that can estimate
>space for non clusterred tables?
>
>thanks
>
>john w.

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Apr 08 1998 - 02:59:20 CDT