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_name to new_name;

DATAFILE
alter database rename file ‘old’ to ‘new’;

LOGFILE
alter database rename file ‘old’ to ‘new’;

TABLESPACE
10g
alter tablespace old rename to 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