exp，imp多用户倒库

1.在cmd下运行

exp system/system110@orcl file=e:/1.dmp log=e:/1.log owner= (JAVAJFPT,JFPT,JFPT_CS)

2.SQLPLUS

create tablespace TSN_UNIONJF datafile 'D:\app\Administrator\oradata\orcl\TSN_UNIONJF01.dbf' size 500m autoextend on next 500m maxsize 32767m extent management local;

create user JAVAJFPT identified by aaa default tablespace TSN_UNIONJF quota 500m on users;

create user JFPT identified by aaa default tablespace TSN_UNIONJF quota 500m on users;

create user JFPT_CS identified by aaa default tablespace TSN_UNIONJF quota 500m on users;

grant CONNECT,RESOURCE to JAVAJFPT;

3. 在cmd下运行

imp system/oracle@orcl file=e:/1.dmp log=e:/1.log owner= (JAVAJFPT,JFPT,JFPT_CS)

4.如果操作失败删除重新搞

drop user JAVAJFPT cascade;
drop tablespace TSN_UNIONJF including contents and datafiles cascade constraints ;