Re: max mumber of views in 10g?

It seems that at least Reference having chapter "A database limits"
(http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/limits.htm#i287876)
haven't any stement about view number although on the other hand it
isn't too hard to check at least for your number and even some times
more than it :)

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create table v (a number);

Table created.
SQL> set timing on
SQL> begin
 2  for i in 1..100000 loop
 3    execute immediate 'CREATE view v' || i || ' as select * from v';
 4  end loop;
 5  end;
 6  /

PL/SQL procedure successfully completed.

Elapsed: 00:16:13.28
SQL> select * from v12502;

no rows selected

Elapsed: 00:00:00.20
SQL> select * from v44444;

no rows selected

Elapsed: 00:00:00.07
SQL> begin
 2  for i in 1..100000 loop
 3    execute immediate 'DROP view v' || i;
 4  end loop;
 5  end;
 6  /

PL/SQL procedure successfully completed.

Elapsed: 01:13:16.20
SQL>

So as always creating a mess (100K views) needs less time (~16 min)
than tidy it up (1 hour 13 min) :))

Gints Plivna
http://www.gplivna.eu




2006/10/20, oracle@xxxxxxxxxxxx <oracle@xxxxxxxxxxxx>: 

hi,

Where can I find the maximum number of views that can be created in 10gR2?
i.e., can 10gR2 allow 40,000 views?  Or is there a limit?

Thanks
--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l


Other related posts: