有谁知道修改字段名的SQL语句？

Question

SQL> desc dinya_test;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL VARCHAR2(30)
 OBJECT_NAME                               NOT NULL VARCHAR2(30)
 SUBOBJECT_NAME                                     VARCHAR2(30)
 OBJECT_ID                                 NOT NULL NUMBER
 DATA_OBJECT_ID                                     NUMBER
 OBJECT_TYPE                                        VARCHAR2(18)
 CREATED                                   NOT NULL DATE
 LAST_DDL_TIME                             NOT NULL DATE
 TIMESTAMP                                          VARCHAR2(19)
 STATUS                                             VARCHAR2(7)
 TEMPORARY                                          VARCHAR2(1)
 GENERATED                                          VARCHAR2(1)
 SECONDARY                                          VARCHAR2(1)
SQL> alter table dinya_test rename column status to aa;Table altered.SQL> desc dinya_test;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                     NOT NULL VARCHAR2(30)
 OBJECT_NAME                               NOT NULL VARCHAR2(30)
 SUBOBJECT_NAME                                     VARCHAR2(30)
 OBJECT_ID                                 NOT NULL NUMBER
 DATA_OBJECT_ID                                     NUMBER
 OBJECT_TYPE                                        VARCHAR2(18)
 CREATED                                   NOT NULL DATE
 LAST_DDL_TIME                             NOT NULL DATE
 TIMESTAMP                                          VARCHAR2(19)
 AA                                                 VARCHAR2(7)
 TEMPORARY                                          VARCHAR2(1)
 GENERATED                                          VARCHAR2(1)
 SECONDARY                                          VARCHAR2(1)SQL>

Answer 1

alter table A rename column AA to BB;

Answer 2

执行修改语句字段名语句后，出现下面错误，不知道是什么原因？
SQL> desc dxsx;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ----------------------
 XH                                                 NUMBER(5)
 BM                                                 VARCHAR2(16)
 EFIELD                                    NOT NULL VARCHAR2(30)
 CFIELD                                    NOT NULL VARCHAR2(50)
 FLEN                                      NOT NULL NUMBER(5)
 FLAG                                               VARCHAR2(1)SQL> alter table dxsc rename column xh to xh1;
alter table dxsc rename column xh to xh1
                        *
ERROR 位于第 1 行:
ORA-14155: PARTITION 或 SUBPARTITION 关键字丢失