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

tracykim10_at_yahoo.com.hk (tracy) wrote in message news:<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

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 -- Received on Tue Jul 06 2004 - 17:04:08 CEST