数据库常用导入导出

删除重复数据
delete from kjcgb_qd
            　　where Cgid in (select Cgid
                                   from kjcgb_qd
                                  group by Cgid
                                           　　having count(Cgid) > 1)
            　　and rowid not in (select min(rowid)
                                  from kjcgb_qd
                                 group by Cgid
                                having count(Cgid) > 1)

导入
imp kjjr/password@orcl  file=E:\TechnologyKJJR\DATABASE\kjjr_orcl_192.168.0.13_2013-01-28-09.dmp full=y
导出
exp kjjr_new/password@orcl file=e:\kjjr_new(dataBase)\kjjr_new20131011.dmp owner=kjjr_new

exp kjjr_new/password@orcl file=e:\kjjr_new(dataBase)\kjjr_newBO_FINANCIALPRODUCTS.dmp tables=(BO_FINANCIALPRODUCTS)

imp kjjr_new/password@orcl file=e:\kjjr_new(dataBase)\kjjr_newBO_FINANCIALPRODUCTS.dmp fromuser=kjjr_new touser=kjjr_new

exp kjjr/1@192.168.8.23:1521/kjpt file=e:\kjjr_new(dataBase)\kjjr_new1118old.dmp owner=kjjr
exp sys/@192.168.8.23:1521/kjpt file=d:\kjjr_new20130918.dmp full=y


exp jsjy1014/1@192.168.0.13:1521/orcl file=e:\kjjr_new(dataBase)\jsjy1104_new.dmp owner=jsjy1014
imp jsjy/1@192.168.8.42:1521/orcl  file=e:\kjjr_new(dataBase)\jsjy1017.dmp fromuser=jsjy1014 touser=jsjy
imp kjjr_new/password@192.168.0.13:1521/orcl  file=e:\kjjr_new(dataBase)\kjjr_new20131029.dmp fromuser=kjjr_new touser=kjjr_new
exp kjjr_new/password@192.168.0.13:1521/orcl  file=e:\kjjr_new(dataBase)\kjjr_new20131029.dmp owner=kjjr_new
imp jsjy/1@192.168.8.42:1521/orcl  file=e:\kjjr_new(dataBase)\jsjy1104_new.dmp fromuser=jsjy1014 touser=jsjy
exp kjjr_new/password@192.168.8.23:1521/kjpt  file=d:\kjjr_new20131120.dmp owner=kjjr_new INDEXES=n STATISTICS=none