help!ORA-01445: cannot select ROWID from a join view without a key-preserved table
From: tracy <tracykim10_at_yahoo.com.hk>
Date: 5 Jul 2004 19:49:24 -0700
Message-ID: <5c91cce9.0407051849.688cd6fa_at_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
SEMESTER_STATUS_DESC
from student_profile, semester_status
where stud_program = SEMESTER_STATUS_PROGRAM
Date: 5 Jul 2004 19:49:24 -0700
Message-ID: <5c91cce9.0407051849.688cd6fa_at_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_PROGRAM",
"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
Received on Tue Jul 06 2004 - 04:49:24 CEST