导出例子:http://expert.csdn.net/Expert/topic/2301/2301105.xml?temp=.2595331
导入例子:http://expert.csdn.net/Expert/topic/2303/2303132.xml?temp=.7162134
Exp/imp 详解:http://www.oradb.net/expimp.htm
导入例子:http://expert.csdn.net/Expert/topic/2303/2303132.xml?temp=.7162134
Exp/imp 详解:http://www.oradb.net/expimp.htm
create table 表名 as select * from a.表名;(数据也过来了)
create table 表名 as select * from a.表名 where 1=2;(只是表结构)
imp system/manager fromuser=olduser touser=newuser full=y file=dmpfile.dmp