建立表空间
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博客 ” ，链接：https://blog.itpub.net/29828180/viewspace-1259544/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
