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

[tracy]

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

student_semeste r is a view with the sql :
CREATE OR REPLACE VIEW "ICEM_USER"."ST UDENT_SEMESTER" ("STUD_ID",
"SEMESTER_STATU S_ID","SEMESTER _STATUS_YEAR",
"SEMESTER_STATU S_SEMESTER","SE MESTER_STATUS_P ROGRAM",
"SEMESTER_STATU S_BRANCH","SEME STER_STATUS_DES C") 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

[Dario]

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

tracykim10@yaho o.com.hk (tracy) wrote in message news:<5c91cce9. 0407051849.688c d6fa@posting.go ogle.com>...

when i run the statement:
SQL select rowid from student_semeste r;
ERROR at line 1:
ORA-01445: cannot select ROWID from a join view without a
key-preserved table
>
student_semeste r is a view with the sql :
CREATE OR REPLACE VIEW "ICEM_USER"."ST UDENT_SEMESTER" ("STUD_ID",
"SEMESTER_STATU S_ID","SEMESTER _STATUS_YEAR",
"SEMESTER_STATU S_SEMESTER","SE MESTER_STATUS_P ROGRAM",
"SEMESTER_STATU S_BRANCH","SEME STER_STATUS_DES C") 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.

[Mark D Powell]

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

tracykim10@yaho o.com.hk (tracy) wrote in message news:<5c91cce9. 0407051849.688c d6fa@posting.go ogle.com>...

when i run the statement:
SQL select rowid from student_semeste r;
ERROR at line 1:
ORA-01445: cannot select ROWID from a join view without a
key-preserved table
>
student_semeste r is a view with the sql :
CREATE OR REPLACE VIEW "ICEM_USER"."ST UDENT_SEMESTER" ("STUD_ID",
"SEMESTER_STATU S_ID","SEMESTER _STATUS_YEAR",
"SEMESTER_STATU S_SEMESTER","SE MESTER_STATUS_P ROGRAM",
"SEMESTER_STATU S_BRANCH","SEME STER_STATUS_DES C") 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 --