Oracle 8i doesn't allow indexes to be created on views. That's why you're seeing the error.
This limitation is not true on other databases. For example, SQL Server 2000 does allow indexes on views, as I found out recently, much to my surprise.
oracle does not allow creation of indexes on views because when a query is executed on the view it usess indexes of underlying tables. Instead you can analyze the query to find out if your query on view is using indexes of the underlying tables.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.