不能 rename 存储过程, 函数

ORACLE 对 表, 视图, 序列, 私有同义词 的 rename 操作不可回滚;

自动将完整性约束, 索引, 授权迁移到 rename 后的 object 上;

rename 表后, 引用表的 视图, 同义词, 存储过程, 函数 都将失效

Caution:
You cannot roll back a RENAME statement.Use the RENAME statement to rename a table, view, sequence, or private synonym.
Oracle Database automatically transfers integrity constraints, indexes, and grants on the old object to the new object.
Oracle Database invalidates all objects that depend on the renamed object, such as views, synonyms, and stored procedures
and functions that refer to a renamed table.