conn system/manager grant connect,resource to a identified by a; grant connect,resource to b identified by b; conn a/a
create table a(a number); insert into a values(1); insert into a values(2); insert into a values(3);
create table b(a number,b varchar2(10)); insert into b values(1,''''1111''''); insert into b values(2,''''2222''''); insert into b values(3,''''3333''''); commit;
2、打开一个DOS窗口、先执行导出
E:\>exp a/a file=a.dmp log=loga.txt
Export: Release 8.1.6.0.0 - Production on 星期五 12月 1 22:24:16 2000
(c) Copyright 1999 Oracle Corporation. All rights reserved.
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
