oracle创建表空间和用户

--创建表空间

CREATE SMALLFILE TABLESPACE test
DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\test'
SIZE 500M AUTOEXTEND
ON NEXT 100K MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

 

--创建用户
CREATE USER sky PROFILE DEFAULT IDENTIFIED BY sky DEFAULT TABLESPACE test ACCOUNT UNLOCK;
GRANT CONNECT TO sky;
GRANT RESOURCE TO sky;