Re: calculate view size

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0203270310.3d080089_at_posting.google.com>...
> sugandha_g_at_yahoo.com (sgupta) wrote in message news:<62deede6.0203260830.3a340139@posting.google.com>...
> > I have 4 views in oracle 8 database, which i want to copy . Is there
> > any command in oracle to calculate view size so i can create
> > tablespace in another db to accomadate these views?
> >
> > Thanks very much!
> >
> > SG
>
> A view is an projection of one or more tables. Hence, unless it is a
> materialized view (which you don't specify), it is a virtual
> representation and it will always occupy 0 bytes.
>
> Regards
>
> Sybrand Bakker
> Senior Oracle DBA

Sorry I made a mistake , I meant 4 tables which I want to copy and not 4 views. I am using vsize , but the tables have many columns so was looking for a better method. Also how accurate is vsize?

Thanks
Sugandha Received on Wed Mar 27 2002 - 15:13:53 CET