oracle中修改表名的几种方式

oracle中修改表名的几种方式

投稿：whsnow 字体：[ 增加  减小] 类型：转载

这篇文章主要介绍了oracle中修改表名的几种方式,需要的朋友可以参考下

id="cproIframe_u1892994_2" width="580" height="90" src="http://pos.baidu.com/acom?adn=3&at=231&aurl=&cad=1&ccd=24&cec=GBK&cfv=16&ch=0&col=zh-cn&conBW=0&conOP=1&cpa=1&dai=2&dis=0&ltr=http%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DKPlI1u8adhzLY0B1aPfdnUHFFBejtWYHg9luzhPV-AeRvHtpyrSWGWImTFiMHWva%26wd%3Doracle%25E6%2580%258E%25E4%25B9%2588%25E6%259B%25B4%25E6%2594%25B9%25E8%25A1%25A8%25E5%2590%258D%26issp%3D1%26f%3D8%26ie%3Dutf-8%26tn%3Dbaiduhome_pg%26inputT%3D9032&ltu=http%3A%2F%2Fwww.jb51.net%2Farticle%2F53003.htm&lu_161=0&lunum=6&n=jb51_cpr&pcs=1084x611&pis=10000x10000&ps=491x77&psr=1440x900&pss=1084x492&qn=c66e512b2944b54f&rad=&rsi0=580&rsi1=90&rsi5=4&rss0=%23FFFFFF&rss1=%23F7FCFF&rss2=%230000ff&rss3=%23444444&rss4=%23008000&rss5=&rss6=%23e10900&rss7=&scale=&skin=tabcloud_skin_3&stid=5&td_id=1892994&titFF=%E5%AE%8B%E4%BD%93&titFS=12&titTA=left&tn=text_default_580_90&tpr=1426651106104&ts=1&version=2.0&xuanting=0&dtm=BAIDU_DUP2_SETJSONADSLOT&dc=2&di=u1892994&tt=1426651106089.454.717.718" align="center,center" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true">

answer1:

ALTER TABLE old_table_name RENAME TO new_table_name;(大写为系统命令)

answer2:

SQL> select tname from tab ;
TNAME
------------------------------
TEST

SQL> rename test to temp ;
Table renamed.

SQL> select tname from tab ;
TNAME
------------------------------
TEMP
rename只能修改自己schema下面的表。

answer3:

create new_table as select * from old_table;drop table old_table;

answer4:

直接在PLSQL Developer里面改