-- 테이블스페이스 생성
CREATE TABLESPACE ts_temp
DATAFILE 'C:\app\Administrator\oradata\orcl11\ts_biowet_temp.DBF' SIZE 100M
 AUTOEXTEND ON
 NEXT 10M
;
 

-- 사용자 생성
CREATE USER user_temp
 IDENTIFIED BY user_pass
 DEFAULT TABLESPACE ts_temp
 TEMPORARY TABLESPACE TEMP;


-- 권한
GRANT connect, dba, resource TO user_temp;





-- 오라클 기동
sqlplus /nolog  
conn / as sysdba;
startup;


shutdown immediate

Posted by incree

2012/10/07 06:57 2012/10/07 06:57
, , , ,
Response
0 Trackbacks , 0 Comments
RSS :
http://www.incree.com/tc/incree/rss/response/157

Trackback URL : 이 글에는 트랙백을 보낼 수 없습니다


Notices

Archives

Authors

  1. incree

Recent Trackbacks

Calendar

«   2017/08   »
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

Site Stats

Total hits:
419290
Today:
94
Yesterday:
111