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
Printable View
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:
but packages. Never heard that it's possible.Code:rename TOI_SEQ_2 to TOI_SEQ_3;
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 :-)Quote:
Originally posted by jamoji
Yes,I know that I can rename tables and sequences,but I'm interested on packages...thanks anyway