Unanswered: How do I create a view using WITH READ ONLY option in 8i
I'm trying to create a view that has a subquery in it using the with read only option in Oracle 8i. When I execute the DDL script I get no errors, but when I try to grant permissions to the newly created view within the same script (after issuing a commit) I get a mesage that the view or table is not found.
The only way I am able to create the view is by removing the with read only option from the end of the view creation command.
I found that Oracle knows this as a bug. There is already a TAR logged on the problem. The situation WILL happen to you if you try to create a read only view AND also try to use the ORDER BY clause (which was what I was trying to do. Thanks for the help.
By the way, the work-around Oracle suggests (i.e. it doesn't look like they're going to work on solving the problem soon) is to create the view as read only and then create another view with the ordering -- a view of a view.