oracle无法重命名服务器名字,oracle中那些对象不支持重命名(转)

oracle中那些对象不支持重命名[@more@]

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