--将一张表的内容复制带新表(操作不同用户下的表需要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;
复制整张表或复制表结构
最新推荐文章于 2024-06-27 16:58:50 发布