I am getting an error when I try to compile a view that has been working fine and I haven’t changed the view (at least not that I know of). The error is ORA 01445 – Cannot select ROWID from a join view without a key-preserved table. But my view is not selecting rowID anywhere. I looked on Metalink and it said to remove the ROWID but I have no ROWID on this view.
what could be the problem???
I am on 9.2.0.5 on Windows 2003
thanks,