Oracle 修改表名

1ALTER TABLE T_PLAT_KEYWORD_STATISTIC RENAME TO T_PLAT_KEYWORD;
2create new_table as select * from old_table;drop table old_table;
3、SQL> select tname from tab;
TNAME
------------------------------
TEST
 
SQL> rename test to temp ;
Table renamed.
 
SQL> select tname from tab ;
TNAME
------------------------------
TEMP

 

posted @ 2014-12-17 10:12  GrandKai  阅读(392)  评论(0)    收藏  举报