Re: max mumber of views in 10g?
- From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
- To: oracle@xxxxxxxxxxxx
- Date: Sun, 22 Oct 2006 17:58:25 +0300
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
