ORA-01031 when creatinf procedures/packages
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-01031 when creatinf procedures/packages

  1. #1
    Join Date
    Feb 2004
    Posts
    35

    ORA-01031 when creatinf procedures/packages

    Hello,
    I used fromuser/touser with export/import to copy data from user1 to user2. All the tables are imported without any problem. However, the stored procedures and packages failed with "ORA-01031: insufficient privileges".
    I tried to created then directly (not import_ but got the same error. Is user2 missing any grants (like create packages etc.?)

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    you're missing privs...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2004
    Posts
    35
    thanks, but which one?

  4. #4
    Join Date
    Feb 2004
    Posts
    35
    never mind...i fixed it.
    the user was missing 'create procedure...'....basics :-(

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