oracle 建表

imp system/sys@TEST file=d:\j3.2017-08-23.bak
修改密码
alter user system identified by system;



以sysdba身份登录
sqlplus / as sysdba




--表空间 
create tablespace J3SPACE   
datafile 'D:/oracle_tablespaces/J3SPACE_TBSPACE.dbf'   
size 1500M   
autoextend on next 5M maxsize 3000M; 


用户 
create user hx_zs identified by hxzs
default tablespace J3SPACE;




赋权
grant connect,resource to hx_zs;  
grant create any sequence to hx_zs;  
grant create any table to hx_zs;  
grant delete any table to hx_zs;  
grant insert any table to hx_zs;  
grant select any table to hx_zs;  
grant unlimited tablespace to hx_zs;  
grant execute any procedure to hx_zs;  
grant update any table to hx_zs;  
grant create any view to hx_zs;  






授予用户使用表空间的权限：
alter user hx_dm_qg quota unlimited on j3SPACE;


删除用户和表空间
drop user j3 cascade;


DROP TABLESPACE j3space INCLUDING CONTENTS AND DATAFILES;




导入导出命令  
exp j3/j3@orcl file=d:/f.dmp full=y  




imp j3/j3@orcl file=C:/Users/Administrator/j320170823.DMP full=y ignore=y