469,296 Members | 2,074 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,296 developers. It's quick & easy.

ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved

ramanan ram
i am using a view query in oracle.if i am run the query successfully executed.but,the same query applying in asp page(front end)it's showing ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table.

please help...
Jul 25 '12 #1
3 5550
8,127 Expert 4TB
Please post the underlying SQL of the view with structure of all the base tables for further analysis.
Jul 26 '12 #2
Expand|Select|Wrap|Line Numbers
here,inside of query using more view..
this query executed in toad ,but front end page(asp) showing error message.
Jul 26 '12 #3
8,127 Expert 4TB
Try to create a materialized view with BUILD IMMEDIATE by using the Underlying SQL.
Jul 30 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by bdj | last post: by
reply views Thread by DavidTurcotte | last post: by
reply views Thread by basmgokul | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.