oracle tablespace, user 추가.

— Tablespace 생성
create tablespace x2_test
datafile ‘x2_test.dbf’ size 100M
autoextend on
next 1M
maxsize 5G;

— 사용자 추가.
create user x2_test identified by 1111
default tablespace x2_test
temporary tablespace temp;

— 권한추가
grant connect, resource to x2_test

drop user x2_test;
drop tablespace x2_test;
select username, account_status from dba_users;

create tablespace OPERA
datafile ‘opera.dbf’
size 500m
autoextend on
next 100m
maxsize 5g;

create temporary tablespace OPERATEMP
tempfile ‘operatemp.dbf’
size 200m
autoextend on
next 100m
maxsize 4g;

create user opera identified by opera
default tablespace OPERA
temporary tablespace OPERATEMP;

grant connect to opera;

grant resource to opera;

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.