建立表空间

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29828180/viewspace-1259544/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29828180/viewspace-1259544/