RENAME
Use the RENAME option of ALTER TABLE to rename a table or to rename a partition.
The following example renames a table: ALTER TABLE emp RENAME TO employee;In the following example, partition EMP3 is renamed: ALTER TABLE employee RENAME PARTITION emp3 TO employee3;
Use the RENAME option of ALTER TABLE to rename a table or to rename a partition.
The following example renames a table: ALTER TABLE emp RENAME TO employee;In the following example, partition EMP3 is renamed: ALTER TABLE employee RENAME PARTITION emp3 TO employee3;
解决方案 »
- oracle11安装后发现没有NLS_LANG
- 请教各们,如何 用C往Oracle中存放数据流
- connection to ":0.0" refused by server
- 对数据库操作时的问题,难道是并发的问题?
- 请介绍下好的ORACLE的学习资料和网站 高分相送,谢谢
- ★★★★★超高难度问题,解决了的给300分,一次虽然只能给100,但我可以给三次的。★★★★★
- 在线等待oracle 求助
- 安装oracle8i for linux碰到个问题,大家帮我一下啊
- 学习oracle 从什么地方开始学起
- select语句连接access数据库正常 但连接oracle数据库出错
- 请教关于在Oracle中使用定时任务
- 奇怪的ora-12154错误??
alter table tbname add (colname type);
也可以通过重新创建表来改变
create tbname2 as select col1,col2 colnew,col3 from tbname1;
drop table tbname1;
rename tbname2 to tbname1;