在数据库的日常维护和管理中，有很多时候需要重名命一些对象的名称，用于备份或其它的相关目的。那么有哪些常见的对象可以直接来rename呢。下面给出它们的列表及相关的命令格式,其中对表空间的重命名需在10g及以后版本中才可以。

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;
COLUMN: ALTER TABLE table_name RENAME COLUMN old TO new;
TABLE: ALTER 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;
SEQUENCE: RENAME oldseq_name TO newseq_name;
DATAFILE: ALTER DATABASE RENAME FILE ‘old’ to ‘new’;
LOGFILE: ALTER DATABASE RENAME FILE ‘old’ to ‘new’;
TABLESPACE: ALTER TABLESPACE old RENAME TO new;
OUTLINE: ALTER OUTLINE old_name RENAME TO new_name;