|
|
|
![]()
| [일반] 테이블 스페이스 , 오라클 사용자 생성 |
|
| 호석 님께서 쓴 글입니다 - 211.♡.74.31 |
읽음:3947 |
|
|
1) 테이블 스페이스 생성
CREATE TABLESPACE RECOVERSPACE
DATAFILE '/oradata/rh2/dataspace/recover01.dbf' SIZE 1000M,
'/oradata/rh2/dataspace/recover02.dbf' SIZE 1000M
MINIMUM EXTENT 100M
DEFAULT STORAGE
(INITIAL 100M
NEXT 50M
MINEXTENTS 1
PCTINCREASE 0) ;
2) 인덱스 테이블 스페이스 생성
CREATE TABLESPACE RECOVERINDEX
DATAFILE '/oradata/rh2/dataspace/recoveridx01.dbf' SIZE 1000M
MINIMUM EXTENT 50M
DEFAULT STORAGE
(INITIAL 50M
NEXT 50M
MINEXTENTS 1
PCTINCREASE 0) ;
3) 유저 생성
CREATE USER DRIMRC
IDENTIFIED BY DRIMRC123
DEFAULT TABLESPACE RECOVERSPACE
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON RECOVERSPACE
QUOTA UNLIMITED ON RECOVERINDEX
QUOTA UNLIMITED ON TEMP ;
GRANT connect, resource to DRIMRC;
# 모든 권한부여
grant create session, select any table, insert any table, update any table, delete any table, unlimited tablespace to drimrc
# 사용자 패스워드 변경
alter user myuser identified by myuser2;
4) 테이블 생성
CREATE TABLE log_bp (
soCd varchar2(7) not null,
screenId char(5) not null,
id varchar2(8) not null,
handleDay char(8),
handleTm char(8),
explain varchar2(100)
)
TABLESPACE codeBuy
STORAGE(INITIAL 1M
NEXT 1M
PCTINCREASE 0
MINEXTENTS 1);
|
|
|
|
|
|
