oracle可以更改表名,sql – 更改Oracle表名

大家好，又见面了，我是你们的朋友全栈君。

我正在尝试在oracle中更改表名.

我首先运行此脚本来声明表

CREATE TABLE CUSTOMER

(

C_ID NUMBER(6,0),

C_LAST VARCHAR2(25),

C_FIRST varchar2(25),

C_MI char(1),

C_DOB DATE,

C_ADDRESS varchar2(100),

C_CITY varchar2(35),

C_STATE char(2),

C_ZIP varchar2(10),

C_DPHONE varchar2(12),

C_EPHONE varchar2(12),

C_USERID varchar2(20),

C_PASSWORD VARCHAR2(30),

CONSTRAINT CUSTOMER_PK PRIMARY KEY(C_ID)

);

CREATE TABLE ORDER_SOURCE

(

OS_ID NUMBER(6),

OS_DESC varchar2(255),

CONSTRAINT ORDER_SOURCE_PK PRIMARY KEY(OS_ID)

);

CREATE TABLE ORDERS

(

O_ID NUMBER(6),

O_DATE DATE,

O_METHPMT varchar2(25),

C_ID NUMBER(6),

OS_ID NUMBER(6),

CONSTRAINT ORDERS_PK PRIMARY KEY(O_ID),

CONSTRAINT ORDERS_CUSTOMER_FK FOREIGN KEY(C_ID) REFERENCES CUSTOMER(C_ID),

CONSTRAINT ORDERS_ORDER_SOURCE_FK FOREIGN KEY(OS_ID) REFERENCES ORDER_SOURCE(OS_ID)

);

它运行正常,然后我尝试运行

alter table ORDERS

rename to ORDER;

我收到此错误：

Error starting at line 1 in command: alter table ORDERS rename to

ORDER Error report: SQL Error: ORA-00903: invalid table name

00903. 00000 – “invalid table name”

*Cause:

*Action:

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/145343.html原文链接：https://javaforall.cn