DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: possible bug in 9.2.0.5

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    possible bug in 9.2.0.5

    Has anyone come across the error ORA-01445: cannot select from a join view without a key preserved table.


    I have a view on the couple joins tables and I can't compile.

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: possible bug in 9.2.0.5

    Originally posted by learning_bee
    Has anyone come across the error ORA-01445: cannot select from a join view without a key preserved table.


    I have a view on the couple joins tables and I can't compile.
    how about a testcase?
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    ORA-01445 cannot select ROWID from a join view without a key-preserved table

    Cause: 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.

    Action: Remove ROWID from the view selection clause, then re-execute the
    statement.

    Sounds fairly self explanitory..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width