469,636 Members | 1,516 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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

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
Jul 19 '05 #1
2 16071
tr********@yahoo.com.hk (tracy) wrote in message news:<5c**************************@posting.google. com>...
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


Tracy,

My guess is that your view has been changed (or underlying tables),
your view is not updateable anymore. Post here full ddl for tables,
including pk constraints.
Jul 19 '05 #2
tr********@yahoo.com.hk (tracy) wrote in message news:<5c**************************@posting.google. com>...
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


Tracy, what chaged between today and the day before yesterday when the
above query worked? Was Forms upgraded? Were either of the two
tables in the view modified? Was the view code replaced? Was index
maintenance ran on either of the base tables resulting in losing a PK
or UK definition?

Find what changed to find the cause of the problem.
HTH -- Mark D Powell --
Jul 19 '05 #3

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 gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.