select 'create table '||object_name||' as select * from '||OWNER||'.'||object_name||';' from all_objects where owner='SCOTT' and object_type='TABLE' create table qixin.EMP as select * from SCOTT.EMP; create table qixin.DEPT as select * from SCOTT.DEPT; Read More