1.创建TABLESPACE
CREATE TABLESPACE "SPACE" LOGGING DATAFILE 'F:\oracle\product\10.1.0
\oradata\bpbj\SPACE.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 1280K
MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT
AUTO;
2。导入DMP
imp userid=xxx/xx fromuser=xx touser=xxfile=e:\db\xxxxDB.dmp
3。DELETE USER
drop user tssa cascade；
4。创建用户
create user xxx identified by xxxx default tablespace xxxxSPACE
temporary tablespace TEMP;
create user xxx identified by xxxx default tablespace xxxSPACE
temporary tablespace TEMP;
grant dba to sxbpbj;
commit;