复制整张表或复制表结构

--将一张表的内容复制带新表（操作不同用户下的表需要dba权限 Database Administrator）create table emp as select * from scott.emp;create table dept as select * from scott.dept;create table salgrade as select * from scott.salgrade;--将一张表的表结构复制带新表create table temp1 as select * from scott.temp2 where 1=2;select　* from emp;