怎么用pl/sql修改表名啊? 查了半天没搞定

[chenhaha]

怎么用sql修改表名啊?
alter table table1 to table2
不成功:(

[dihai2000]

rename

[kerisyml]

alter table rename table1 to table2;

[LGQDUCKY]

用pl/sql修改表名
execute immediate 'rename table_name1 to table_name2';

[beckhambobo]

Rename Partition Examples
The following statement renames a table:

ALTER TABLE emp RENAME TO employee;


In the following statement, partition emp3 is renamed:

ALTER TABLE employee RENAME PARTITION emp3 TO employee3;

[skyxj]

收工啦

[RomanticProgrammer]

:)

[nyfor]

rename table1 to table2;

如果你是要在存储过程中使用，那么由于是DDL语句，你需要使用动态SQL来首先
execute immediate 'rename table1 to table2'

[chenhaha]

多谢:)