oracle创建用户导入数据

--删除表空间
drop tablespace PMSTEST_TEMP including contents and datafiles;
drop tablespace PMSTEST_DATA including contents and datafiles;

--select username,sid,serial# from v$session;
--alter system kill session '160,1769';

select username from dba_users;

drop user PMSTEST cascade;

--drop tablespace wds_temp including contents and datafiles
--创建临时表空间
create temporary tablespace pmstest_temp
tempfile 'D:\oracle11g\oradata\pmstest_temp.dbf'
size 10m  
autoextend on  
next 20m maxsize 2048m  
extent management local;

--创建数据表空间
create tablespace pmstest_data  
logging  
datafile 'D:\oracle11g\oradata\pmstest_data.dbf'
size 10m  
autoextend on  
next 20m maxsize 2048m  
extent management local;

--创建用户并指定表空间
/*create user pmstest identified by pmstest
default tablespace pmstest_data  
temporary tablespace pmstest_temp;

--给用户授予权限
grant connect,resource,dba to pmstest;


*/
---创建用户
create user pmstest
  identified by "pmstest"
  default tablespace pmstest_data
  temporary tablespace pmstest_temp
  profile DEFAULT;
----赋予用户权限
grant connect to pmstest;
grant dba to pmstest;
grant resource to pmstest;


  grant select on sys.dba_pending_transactions to pmstest;
  grant select on sys.pending_trans$ to pmstest;
  grant select on sys.dba_2pc_pending to pmstest;
  grant execute on sys.dbms_system to pmstest;

---------------------------------------------------------
--导入数据库
--imp pmstest/pmstest@ORCL file=C:\pms20150108.dmp full=yes ignore=y
--修改密码
--update t_sys_user t set t.passd='z80ghJXVZe9m59/5+Ydk2g=='--0