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_at_digistar.com <oracle_at_digistar.com>:
>
> 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