D:\oracle\oradata\SCCOT.DBF
D:\oracle\oradata\SCCOT_INDEX.DBF
-------------------------------------------------------------------------------------------------
drop user sccot cascade;
drop tablespace sccot including contents and datafiles;
drop tablespace scott_index including contents and datafiles;
1. tablespace 생성
create tablespace sccot datafile 'D:\oracle\oradata\SCCOT.DBF' size 100M extent management local uniform size 1M;
create tablespace scott_index datafile 'D:\oradata\SCOOT_INDEX.dbf' size 50M extent management local uniform size 1M;
2. user 생성
create user sccot
identified by "sccot123"
default tablespace SCOOT
temporary tablespace temp
quota unlimited on SCCOT;
quota unlimited on SCCOT_INDEX;
3. 접속,리소스 권한 부여
grant connect, resource to sccot;
-------------------------------------------------------------------------------------------------
SELECT * FROM DBA_USERS ORDER BY USERNAME;
SELECT * FROM DBA_TABLESPACES ORDER BY TABLESPACE_NAME;
DROP USER XXX CASCADE;
DROP TABLESPACE XXX INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
'DATABASE > Oracle' 카테고리의 다른 글
[오라클] INSERT INTO ~ SELECT (0) | 2014.07.04 |
---|---|
[오라클] 테이블 복사 (0) | 2014.07.04 |
[오라클] exp & imp (0) | 2014.06.29 |
[오라클] 세션 확인 & 킬 (0) | 2014.06.29 |
[오라클] expdp & impdp (1) | 2014.05.11 |