1 /*此处默认数据库实例为ORCL, 为ORCL创建一个永久性的表空间, 区定制分配, 段采用自动管理方式*/
2 CREATE TABLESPACE ORCLTBS01 DATAFILE
3 'D:\app\darkdog\oradata\ORCL\ORCLTBS01_1.DBF' SIZE 50M;
4
5 /*为ORCL创建临时表空间*/
6 CREATE TEMPORARY TABLESPACE ORCLTEMP01 TEMPFILE
7 'D:\app\darkdog\oradata\ORCL\ORCLTEMP01_1.DBF' SIZE 20M
8 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M;
9
10 /*创建用户*/
11 CREATE USER ddog IDENTIFIED BY &pass;
12
13 /*修改用户默认表空间*/
14 ALTER USER ddog DEFAULT TABLESPACE ORCLTBS01
15 QUOTA UNLIMITED ON ORCLTBS01;
16
17 /*修改用户默认临时表空间*/
18 ALTER USER ddog TEMPORARY TABLESPACE ORCLTEMP01;
19
20 /*授权*/
21 GRANT CONNECT TO ddog;
22 GRANT RESOURCE TO ddog;
