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;  

create table qixin.BONUS as select * from SCOTT.BONUS;  

create table qixin.SALGRADE as select * from SCOTT.SALGRADE;

create table qixin.ORDERS as select * from SCOTT.ORDERS;  

create table qixin.STUDENT as select * from SCOTT.STUDENT;