-
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
-
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
-
Yes,I know that I can rename tables and sequences,but I'm interested on packages...thanks anyway
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|