创建表空间

sytstem 用户登录，orcl——tns:

orcl =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

--创建表空间语句：
create tablespace user_data   datafile 'D:\ test.dbf' size 50m  
autoextend on  next 50m maxsize 20480m   extent management local;

--创建表空间内的用户：
create user dyg01 identified by password  default tablespace user_data;

--给用户授予权限：

grant connect,resource,dba to dyg01;