oracle常用功能语句

ptajxcqvnd

<!--新建用户-->
create user HIRISUN identified by hirisun;
<!--新建表空间-->
create tablespace hirisun_space datafile 'd:\dataBase\HIRISUNDATA.DBF' size 5120m;
<!--修改用户默认表空间-->
alter user HIRISUN default tablespace hirisun_space;
<!--赋予用户权限-->
grant create session  to HIRISUN;
grant connect,resource to HIRISUN;
<!--赋予用户ＤＢＡ权限(普通用户不用)-->
GRANT DBA TO HIRISUN;
<!--导入dmp文件的语句(根据情况修改库名等)-->
exp TMREMOTEEDU/remoteedu@orcl file=d:\tmremoteedu.dmp owner=(orcl,TMREMOTEEDU)
imp HIRISUN/hirisun@scga-new  file='D:\数据\full.dmp' log='D:\dataBase\hirisunData.log' fromuser=HIRISUN touser=HIRISUN  ignore=y  full=y;
<!--查看用户的默认表空间-->
select username, DEFAULT_TABLESPACE from dba_users a where a.username='HIRISUN';
<!--删除用户-->
drop user HIRISUN cascade;
<!--删除表空间-->
drop tablespace hirisun_space INCLUDING CONTENTS AND DATAFILES;
<!--解锁/锁定帐户-->
alter user HIRISUN account unlock/lock;
<!-- 修改用户密码 -->
alter user TMREMOTEEDU identified by remoteedu;
<!--杀用户session-->
alter system kill session'151,2333';
select saddr,sid,serial#,paddr,username,status from v$session where username is not null
alter database open;