oracle导入导出

exp tuser/cabletech@127.0.0.1/orcl file = d:\exp.dmp tables=(JL_JF_DETAIL) query = \"where oildate like '2016%'\"

exp tuser/123456@127.0.0.1/orcl file = d:\exp.dmp tables=(aaaa)

imp tuser/cabletech@127.0.0.1:1521/orcl file=d:\exp.dmp log=d:\exp.log fromuser=tuser touser=tuser constraints=N ignore=y

imp tuser/123456@127.0.0.1:1521/orcl file=E:\代维数据库\tuser2.dmp ignore=y tables=(JL_PBOSSNWG_NUM)

导入以JBPM4开头的表

imp tuser/123456@127.0.0.1:1521/orcl file=E:\代维数据库\tuser2.dmp ignore=y tables=JBPM4%

alter tablespace users add datafile  'D:\oradata\USERS_03.DBF' size 2000m;