不能 rename 存储过程, 函数

最新推荐文章于 2022-09-26 16:51:52 发布

阳光黯淡

最新推荐文章于 2022-09-26 16:51:52 发布

阅读量1.1k

点赞数

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.