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

Thread: Ora-01403 error

  1. #1
    Join Date
    Jun 2005
    Posts
    5

    Question Ora-01403 error

    We created two users(A,B),sometimes we have to copy some data from one to the other.When I did it in Golden32.exe which was the third part software like PL/SQL. The ora-01403 error appeared. it said '' Can't find any data'', In fact there were a lot of data in that table ,But some tables can do like this .I used SQL sentences as following:

    insert into B.table1 ( select * from A.table1 where [conditions])

    I didn't know the reason, so I need some help from Oracle expert.
    (The table's structure of A and B are the same )

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    break down the query into into subsequent parts, see which part is failing

    i.e run the select on its own, see what it returns
    make sur eyou have the proper permissions on the table as well

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