Re: Limitation on Views

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 08 Aug 1999 14:17:25 GMT
Message-ID: <37b19144.7183749@newshost.us.oracle.com>

A copy of this was sent to "Nicolas Bronke" <news_at_TRINITY.de> (if that email address didn't require changing) On Sat, 7 Aug 1999 20:44:56 +0200, you wrote:

>> Number of views in database - no limit (assuming sufficient space in
>> SYSTEM tablespace)
>>
>The views are stored in the system tablespace?
>

as are all data dictionary objects. the view definitions are stored in the system tablespace. The data the view points to probably isn't but the view definition is.

>Regards
>Nicolas
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Aug 08 1999 - 09:17:25 CDT