oracle迁移数据库语句

--创建oracle 表空间
create tablespace xzsp_data   
logging   
datafile 'E:\app\Administrator\oradata\db3\xzsp_data.dbf'   
size 2048m
autoextend on
next 32m maxsize 30720m   
extent management local; 


-- 创建用户
create user WELL_PT_004   
default tablespace xzsp_data IDENTIFIED BY WELL_PT_004
  temporary tablespace TEMP
  profile DEFAULT
  quota unlimited on users;
-- Modify the user 
alter user WELL_PT_004 identified by WELL_PT_004;
-- Grant/Revoke object privileges 
grant read, write on directory BACKUP to WELL_PT_004;
grant select on DBA_2PC_PENDING to WELL_PT_004;
grant select on DBA_PENDING_TRANSACTIONS to WELL_PT_004;
grant execute on DBMS_XA to WELL_PT_004;
grant select on PENDING_TRANS$ to WELL_PT_004;


grant create session to WELL_PT_004;
grant resource  to WELL_PT_004;




-- 创建用户
create user XZSP_004  
default tablespace xzsp_data identified by XZSP_004
temporary tablespace TEMP
  profile DEFAULT
  quota unlimited on users;
-- Modify the user 
alter user LDX_01 identified by XZSP_004;
-- Grant/Revoke object privileges 
grant read, write on directory BACKUP to XZSP_004;
grant select on DBA_2PC_PENDING to XZSP_004;
grant select on DBA_PENDING_TRANSACTIONS to XZSP_004;
grant execute on DBMS_XA to XZSP_004;
grant select on PENDING_TRANS$ to XZSP_004;


grant create session to XZSP_004;
grant resource  to XZSP_004;


--删除用户
drop user ×× cascade


--删除表空间
DROP TABLESPACE tablespace_name INCLUDING CONTENTS AND DATAFILES;


impdp system/admin888 directory=backup dumpfile=XZSP_004_20150416.DMP REMAP_SCHEMA=XZSP_004:XZSP_004 remap_tablespace=TEST_DATA:xzsp_data