| Oracle/MySQL 관련 게시판 |
|---|
| 2014/03/14(16:59) from 203.237.213.6 | |
| 작성자 : 주인장 | 조회수 : 3220 , 줄수 : 28 |
| [Oracle] 명령어로 tablespace 생성 -> 사용자생성 -> 권한부여 |
|---|
|
C:\>sqlplus SQL*Plus: Release 11.2.0.2.0 Production on 금 3월 14 16:58:46 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: system Enter password: Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL> SQL> create tablespace oracledb datafile 'c:\oracledb.dbf' size 100m; Tablespace created. SQL> create user eskang identified by eskang1234 default tablespace oracledb; User created. SQL> grant connect,dba to eskang; Grant succeeded. SQL> conn eskang/eskang1234; Connected. |
|
|