Re: max mumber of views in 10g?

Since one of our 3rd Party COTS apps created about 35,000 views in our 8i Production database and over 40,000 views in 9i (much to our dismay, but Oracle didn't complain), I can't imagine that 10g would allow fewer.

Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)

 I feel so unnecessary. -- Rufus Thomas

               ( "Do the Funky Chicken")

oracle_at_digistar.com
Sent by: oracle-l-bounce_at_freelists.org
10/20/2006 09:26 AM
Please respond to
oracle_at_digistar.com

To
oracle-l_at_freelists.org
cc

Subject
max mumber of views in 10g?

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 Received on Fri Oct 20 2006 - 09:29:52 CDT