Problem solve Get help with specific problems with your technologies, process and projects.

Any limit to number of views in 9i?

Is there a limit to the number of views that can be created in an Oracle9i database?
Chapter 4 of the Oracle9i Database Reference is where logical database limits are documented. There is no listed limit on the number of views that can be created.

Of course, there's a sensible limit on the number of views and your question leads me to want to know why you are creating enough views to think that you may hit a limit. There are a lot of features in Oracle that compliment views and you may want to think about using them. If you're thinking about creating separate views for each user, then consider Fine-Grained Access Control (FGAC) to implement one type of row-level security on the table. If you really think you may have enough views to hit a limit, then you may wish to reexamine your database design to ensure it is meeting your needs.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.