复制整张表或复制表结构

--将一张表的内容复制带新表（操作不同用户下的表需要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;