查看所有表（plsql此用户登录后）//查此用户下
select table_name from user_tables;
//统计所有表
select count(table_name) from user_tables;


--删除表空间

DROP TABLESPACE bjhts INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE bjhts_temp INCLUDING CONTENTS AND DATAFILES;

--删除用户
drop user bjhts cascade


--创建表空间
create temporary tablespace bjhts_temp  
tempfile 'D:\oracle\tablespace\bjhts_temp.dbf' 
size 1024m  
autoextend on  
next 1024m maxsize 2048m  
extent management local;  

create tablespace bjhts  
logging  
datafile 'D:\oracle\tablespace\bjhts.dbf' 
size 1024m  
autoextend on  
next 1024m maxsize 10240m  
extent management local;  


--创建用户（用户在表空间下）
create user bjhts identified by bjhts  
default tablespace bjhts  
temporary tablespace bjhts_temp;  

grant connect,resource,dba to bjhts;  




--执行命令导入dmp

imp userid=用户名/密码@orcl file=d:\xxx.dmp full=y