Re: calculate view size
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 27 Mar 2002 03:10:31 -0800
Message-ID: <a20d28ee.0203270310.3d080089_at_posting.google.com>
Date: 27 Mar 2002 03:10:31 -0800
Message-ID: <a20d28ee.0203270310.3d080089_at_posting.google.com>
sugandha_g_at_yahoo.com (sgupta) wrote in message news:<62deede6.0203260830.3a340139_at_posting.google.com>...
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
> 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
Senior Oracle DBA
Received on Wed Mar 27 2002 - 12:10:31 CET