数据库导入

查询表空间状态:
select * from dba_tablespaces
查询表空间与数据文件对应关系

select tablespace_name, bytes, file_name from dba_data_files;

select name from v$database;
select instance_name from v$instance; 

create tablespace liuye datafile '/snow/liuye.dbf' size 100M;  
--DROP TABLESPACE whc_tbs INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;  
create user liuye identified by liuye default tablespace liuye;  
   
grant connect,resource to liuye;   
grant dba to liuye;  
--Revoke dba from whc;  

imp

对方数据的名字。