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@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 Mon Jul 05 2004 - 21:49:24 CDT