create tablespace hdsms
logging
datafile '/oracle/oradata/hdsms/hdsms.dbf'
size 32m
autoextend on
next 32m maxsize 4096m
extent management local
create user hdsms identified by hdsms
default tablespace hdsms
grant create view,connect,resource to hdsms;
alter user hdsms quota 5M on hdsms quota 1M on hdass; --一个用户对多个表空间
grant unlimited tablespace to hdsms; --表空间取消限额
alter user scott account unlock;--用户解锁
alter user scott identified by pan; --修改密码
select * from dba_db_links 查看连接数
select * from v$process
logging
datafile '/oracle/oradata/hdsms/hdsms.dbf'
size 32m
autoextend on
next 32m maxsize 4096m
extent management local
create user hdsms identified by hdsms
default tablespace hdsms
grant create view,connect,resource to hdsms;
alter user hdsms quota 5M on hdsms quota 1M on hdass; --一个用户对多个表空间
grant unlimited tablespace to hdsms; --表空间取消限额
alter user scott account unlock;--用户解锁
alter user scott identified by pan; --修改密码
select * from dba_db_links 查看连接数
select * from v$process
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29828180/viewspace-1259544/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29828180/viewspace-1259544/