Re: calculate view size
Date: Wed, 27 Mar 2002 15:36:01 GMT
Message-ID: <BFlo8.140097$uA5.123430_at_rwcrnsc51.ops.asp.att.net>
vsize gives you the actual size so it is very accurate. Why not use the
dbms_space package on each table and estimate from there? Or write sql to
write sql with vsize.
Jim
"sgupta" <sugandha_g_at_yahoo.com> wrote in message
news:62deede6.0203270613.29119a7b_at_posting.google.com...
> 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_at_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 - 16:36:01 CET