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

Thread: Change name

  1. #1
    Join Date
    Jan 2002
    Posts
    152
    Can I rename a package,sequence or any other object from my database.
    I can do it with tables:
    rename old_name to new_name;
    But I don't know the way with other objects..
    Thanks

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    You can rename a table, a sequence like:

    Code:
    rename TOI_SEQ_2 to TOI_SEQ_3;
    but packages. Never heard that it's possible.

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Jan 2002
    Posts
    152
    Yes,I know that I can rename tables and sequences,but I'm interested on packages...thanks anyway

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by jamoji
    Yes,I know that I can rename tables and sequences,but I'm interested on packages...thanks anyway
    Oracle gives "ORA-03001: unimplemented feature" when trying to rename a function or a package. Even in 9i. May be in 10i it will be implemented :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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