471,316 Members | 1,217 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,316 software developers and data experts.

Re: help!ORA-01445: cannot select ROWID from a join view without a key-preserved table

Oracle does not know which table's rowid to return from this view and
thus it gives an error.

What this means is that one of the underlying tables in the view has
to have either a primary key or a unique index that will ensure the
result is unique.
The result of the query does not have to contain the key of the table
but must act as though the key was used.
http://download-west.oracle.com/docs...03sch.htm#1044

TODO: check your schema to make sure that there is a primary key or
unique index on your table that has only unique records.

tracy wrote:
when i run the statement:
SQL select rowid from student_semester;
ERROR at line 1:
ORA-01445: cannot select ROWID from a join view without a
key-preserved table

student_semester is a view with the sql :
CREATE OR REPLACE VIEW "ICEM_USER"."STUDENT_SEMESTER" ("STUD_ID",
"SEMESTER_STATUS_ID","SEMESTER_STATUS_YEAR",
"SEMESTER_STATUS_SEMESTER","SEMESTER_STATUS_PROGRA M",
"SEMESTER_STATUS_BRANCH","SEMESTER_STATUS_DESC ") AS
select
STUD_ID ,
SEMESTER_STATUS_ID ,
SEMESTER_STATUS_YEAR ,
SEMESTER_STATUS_SEMESTER ,
SEMESTER_STATUS_PROGRAM ,
SEMESTER_STATUS_BRANCH ,
SEMESTER_STATUS_DESC
from student_profile, semester_status
where stud_program = SEMESTER_STATUS_PROGRAM
Now, my users can't run query from a forms, which contains this
tables. Before yesterday, they able to do this.

Pls tell me what;s wrong and how to fix it.
TQ!

regards,
Tracy
Jun 27 '08 #1
0 2990

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Tom | last post: by
4 posts views Thread by Sarir Khamsi | last post: by
2 posts views Thread by Sudheer Kareem | last post: by
6 posts views Thread by wukexin | last post: by
reply views Thread by tbatwork828 | last post: by
3 posts views Thread by Colin J. Williams | last post: by
5 posts views Thread by Steve | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.