ORA-01445
Error: ORA-01445: cannot select ROWID from a join view without a key-preserved table
Causa: A SELECT statement attempted to select ROWIDs from a view derived from a join operation. Because the rows selected in the view do not correspond to underlying physical records, no ROWIDs can be returned.
Acción: Remove ROWID from the view selection clause, then re-execute the statement.
COMENTARIOS:
por Oscar | 12/02/2013 18:04:53
RE: ORA-01445
select SC.SC_ID, IO.IO_ID, RD.MAT_ID , S.NAME, R.LOGISTIC, R.REQUEST_DATE, R.REQUIRED_DATE, C.CURRENCY, B.BUYER_NAME, SC.SC_DATE, SC.SC_NUMBER, SC.AMOUNT, SC.RFQ, SC.RFQ_DATE, SC.QUOTATION_DATE, SC.REQUI, SC.PO_NUMBER, SC.PO_DATE, SC.PO_DATE, SC.DELIVERY_DATE, SC.COMMENTS, SC.CANCELED
from Shopping_Cart SC
LEFT JOIN REQUEST_DETAIL RD ON RD.SC_ID= SC.SC_ID
LEFT JOIN INTERNAL_OFFER IO ON IO.DEPT_ID= RD.REQ_ID
LEFT JOIN SUPPLIERS S ON S.SUPPLIER_ID = RD.SUPPLIER_ID
LEFT JOIN REQUESTS R ON R.REQ_ID= RD.REQ_ID
LEFT JOIN CURRENCY C ON C.CURRENCY_ID= SC.CURRENCY_ID
LEFT JOIN BUYERS B ON B.BUYER_ID = SC.BUYER_ID
"The report query needs a unique key to identify each row. The supplied key cannot be used for this query. Please edit the report attributes to define a unique key column. ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table"
hi, im very very new on this, and i cant find the solution for this, maybe it´s something easy or maybe is not, but any help on this would be great
Thank you!