Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Sun Oct 22 2006 - 09:58:25 CDT
![]() |
![]() |