oracleユーザーと表領域の作成
, 。
:
1. , ( ) :
create user username identified by password;
username:
password:
, , : scott
2. :
create tablespace tablespacename datafile 'd:\data.dbf' size xxxm;
tablespacename:
d:\data.dbf':
xxx ,m (M)
3. :
alert user username default tablespace tablespacename;
tablespacename username
4. :
grant create session,create table,unlimited tablespace to username;
5. , 。
conn username/password;