oracle 创建用户 导入dmp文件

------------------------------------------------------------------------------------
------------------------------------------------------------------------------------
 
查找用户 select username from dba_users;

删除用户 drop user "tcposp1" cascade

------------------------------------------------------------------------------------
------------------------------------------------------------------------------------
数据库启动与重启
（1）以oracle用户登录
（2）sqlplus / as sysdba
（3）shutdown immediate
（4）startup
------------------------------------------------------------------------------------
------------------------------------------------------------------------------------

12、导入dmp
imp gesstest/gesstest@orcl file=gess.dmp fromuser=### touser=### full=y

imp gesshxbcs/gesshxbcs@32ENV file=gess.dmp fromuser=gesstest touser=gesshxbcs full=y

导出dmp
exp   gesshxbcs/gesshxbcs@32ENV    full=y   FILE=f:\TEST.DMP

======================================
创建用户
--drop user gesspsbc cascade;
create user gesspsbc identified by gesspsbc                                    
    default tablespace TS_GESS_DATA_01 ;   
grant connect,resource to gesspsbc;
grant create any table to gesspsbc;  
grant alter any table to gesspsbc;
grant create view to gesspsbc;
grant create any procedure to gesspsbc;
grant unlimited tablespace to gesspsbc;

------------------------------------------------------------------------------------
------------------------------------------------------------------------------------
oracle 表空间 用户创建过程

create tablespace tcposp1  datafile '/oracle/datefile/tcposp1.dbf' size 100M default storage (initial 500K Next 500K minextents 1 maxextents unlimited  pctincrease 0);

create user tcposp1_1 identified by tcposp1_1 default tablespace tcposp1;

grant resource,connect to TCPOSP1_1;

commit;