oralce建立表空间

create temporary tablespace coalfinally_temp 

tempfile 'F:\oracle\product\10.2.0\oradata\orcl\coalfinally\coalfinally_temp.dbf'

size 50m 

autoextend on 

next 50m maxsize 20480m 

extent management local; 

 

/*第2步：创建数据表空间  */

create tablespace coalfinally 

logging 

datafile 'F:\oracle\product\10.2.0\oradata\orcl\coalfinally\coalfinally.dbf'

size 50m 

autoextend on 

next 50m maxsize 20480m 

extent management local; 

 

/*第3步：创建用户并指定表空间  */

create user coalfinally identified by coalfinally 

default tablespace coalfinally 

temporary tablespace coalfinally_temp; 

 

/*第4步：给用户授予权限  */

grant connect,resource,dba to coalfinally;