一.创建空表.

sql> create table test_dept as select * from scott.dept where rownum>1000;


二.从其它表按字段插入指定数据

sql> insert into test_dept(deptno, dname)  select deptno, dname from scott.dept;