Ask Experts Questions for FREE Help !
Ask
    madana's Avatar
    madana Posts: 1, Reputation: 1
    New Member
     
    #1

    Oct 1, 2009, 01:39 AM
    Oracle a query the error ORA-01445
    ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

    I am running a query on Oracle 10G database.
    Why this error occurs and what is a key-preserved table.
    If I run the query without the view it runs.
    When I join the view to the query I get the error.
    Can you help resolving this.
    Thanks and Regards
    Madana
    fozzyman's Avatar
    fozzyman Posts: 1, Reputation: 1
    New Member
     
    #2

    Nov 18, 2009, 07:13 AM
    I had the same problem.
    In my case I solved by limiting the number of columns in the join:
    ex.

    select * from tableA a join tableB b on (a.column = b.column)

    by

    select * from tableA a join (select column from tableB) b on (a.column = b.column)

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Oracle Error 12560:tns Protocol Adapter Error [ 3 Answers ]

Hi, Whenever I try to log in using SCOTT/TIGER userid, I get the error "ORA ERROR 12560:TNS PROTOCOL ADAPTER ERROR". I tried starting the listener from administration-> services, but still the problem persists. Can you please suggest a solution?

ORA 01034 :tns error oracle not available [ 5 Answers ]

At the time of login using scott/tiger I'm getting this error Sm1 help me out :(

Error in oracle 10g [ 3 Answers ]

HELLO I AM SRIRAM I AM FROM CHENNAI INDIA After installing oracle 10g and while running forms I am getting error message 12560 tns protocol adapter error Can somebody tell me how to resolve the problem


View more questions Search