-- 테이블스페이스 생성
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/10   »
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:
428045
Today:
85
Yesterday:
91