Xref: alice comp.databases.oracle.server:60825 Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!su-news-hub1.bbnplanet.com!paloalto-snf1.gtei.net!news.gtei.net!inet16.us.oracle.com!not-for-mail From: tkyte@us.oracle.com (Thomas Kyte) Newsgroups: comp.databases.oracle.server Subject: Re: Limitation on Views Date: Sun, 08 Aug 1999 14:17:25 GMT Organization: Oracle Service Industries Lines: 27 Message-ID: <37b19144.7183749@newshost.us.oracle.com> References: <7o4ugc$5mq$1@nnrp1.deja.com> <37A5A88F.77EA@yahoo.com> <37ad72a4@news.uk.ibm.net> Reply-To: tkyte@us.oracle.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: inet16.us.oracle.com 934121678 18128 130.35.30.103 (8 Aug 1999 14:14:38 GMT) X-Complaints-To: usenet@inet16.us.oracle.com NNTP-Posting-Date: 8 Aug 1999 14:14:38 GMT X-Newsreader: Forte Agent 1.5/32.451 A copy of this was sent to "Nicolas Bronke" (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@us.oracle.com Oracle Service Industries Reston, VA USA Opinions are mine and do not necessarily reflect those of Oracle Corporation