ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

Raj_Kumar Dec 12, 2016 3:43 AM

Hi,

I am gettig error while running IR report from two tables. Query working on sql commands but getting error "ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table" in interactive report.

Thanks

Raj Kumar

1. Re: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

Scott Wesley Dec 12, 2016 4:02 AM (in response to Raj_Kumar)

Try taking off the link to single record option in the IR attributes.
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.