创建oracle数据库表空间与创建用户

创建表空间

create tablespace ENRTANCE_TABLE_DATA datafile 'F:\DATABASE\ORACLE\ORADATA\enrtance\ENRTANCE_TABLE_DATA_1.DBF'

size 200m

autoextend on

next 32m maxsize 2048m

extent management local;

=================================================

创建用户

CREATE USER peng IDENTIFIED BY peng

PROFILE DEFAULT

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

ACCOUNT UNLOCK;

grant create session to peng;

grant create table,create view,create trigger, create sequence,create procedure to peng;

grant unlimited tablespace to peng;

grant select on v_$statname to peng;

grant select on v_$sesstat to peng;

grant select on v_$session to peng;

grant select on v_$mystat to peng;

GRANT

CREATE SESSION, CREATE ANY TABLE , CREATE ANY VIEW , CREATE ANY INDEX , CREATE ANY PROCEDURE ,

ALTER ANY TABLE , ALTER ANY PROCEDURE ,

DROP ANY TABLE , DROP ANY VIEW , DROP ANY INDEX , DROP ANY PROCEDURE ,

SELECT ANY TABLE , INSERT ANY TABLE ,UPDATE ANY TABLE创建数据库表, DELETE ANY TABLE

TO peng;

grant exp_full_database to peng;

grant imp_full_database to peng;

================================================

表解锁

SELECT object_name, machine, s.sid, s.serial#

FROM gv$locked_object l, dba_objects o, gv$session s

WHERE l.object_id= o.object_id

AND l.session_id = s.sid;

ALTER system kill session '249, 35533';

（编辑：威海站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!