Oracle对象支持重命名

最新推荐文章于 2026-01-09 14:20:30 发布

转载最新推荐文章于 2026-01-09 14:20:30 发布 · 178 阅读

文章标签：

本文讨论了Oracle数据库中不能重命名的元素，包括CLUSTER、FUNCTION、INDEX、PACKAGE、PACKAGEBODY、PROCEDURE、SEQUENCE、SYNONYM、COLUMNALTERTABLE、TABLERENAME、TABLEPARTITIONALTERTABLE、TABLESUBPARTITIONALTERTABLE、TRIGGER、CONSTRAINT、VIEW、数据文件和日志文件重命名等，并介绍了如何通过特定命令进行操作。

CLUSTER can’t be renamed.
FUNCTION can’t be renamed.
INDEX ALTER INDEX old_name RENAME TO new_name;
INDEX PARTITION ALTER INDEX index_name RENAME PARTITION partition TO new_name;
INDEX SUB PARTITION ALTER INDEX index_name RENAME SUBPARTITION subpartition TO new_name;
LOB ALTER TABLE T MOVE LOB(lob_column) STORE AS newlogseg_name;
PACKAGE can’t be renamed.
PACKAGE BODY can’t be renamed.
PROCEDURE can’t be renamed.
FUNCTION can’t be renamed.
SEQUENCE RENAME oldseq_name TO newseq_name;
SYNONYM can’t be renamed.
COLUMN ALTER TABLE table_name RENAME COLUMN old TO new;
TABLE RENAME old_table TO new_table;
TABLE PARTITION ALTER TABLE table_name RENAME PARTITION partition TO new_name;
TABLE SUB PARTITION ALTER TABLE table_name RENAME SUBPARTITION subpartition TO new_name;
TRIGGER ALTER TRIGGER old_name RENAME TO new_name;
CONSTRAINT ALTER TABLE table_name RENAME CONSTRAINT old_name TO new_name;
VIEW RENAME old_table TO new_table;
datafile alter database rename file ‘old’ to ‘new’;
logfile alter database rename file ‘old’ to ‘new’;
TABLESPACE ALTER TABLESPACE old RENAME TO new; [10g new]
OUTLINE ALTER OUTLINE old_name RENAME TO new_name;
SCHEMA can’t be renamed.
DATABASE modify db_name in init.ora and recreate controlfile
INSTANCE shutdown;change ORACLE_SID;startup