Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    3

    Unanswered: How to change the owner of a procedure.

    I am having some 100 procedure under a schema(emp) . I want to move all the procedure to some other schema(admin).

    How to do that?
    what are all the permission need to be checked for new schema to access that procedures ?

    Regards
    Murugesan

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    you can use the dbms_metadata package to extract to DDL
    and then run the script as admin and create all the objects again

    you can't modify the source$ attributes

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Do this
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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