复制数据copy from

 /*复制数据*/

copy from system/system@spms  to system/system@orcl create mwt_pd_deps using select * from mw_sys.mwt_pd_deps

select * from mw_sys.mwt_pd_deps where rownum<=3;

select * from MWT_PD_DEPS;
SELECT * FROM DBA_OBJECTS WHERE OBJECT_TYPE='TABLE' AND OBJECT_NAME='MWT_PD_DEPS'

select * from dba_tables where table_name=upper('mwt_pd_deps')