-- 创建临时表空间 |
02 | create temporary tablespace os_temp |
03 | tempfile 'C:/Oracle/product/10.2.0/oradata/os_temp.dbf' |
04 | size 100m |
05 | autoextend on |
06 | next 100m maxsize 1024m |
07 | extent management local ; |
08 |
09 | -- 创建数据表空间 |
10 | create tablespace os_data |
11 | datafile 'C:/Oracle/product/10.2.0/oradata/os_data.dbf' |
12 | size 100m |
13 | autoextend on |
14 | next 100m maxsize 1024m |
15 | extent management local ; |
16 |
17 | -- 创建用户 |
18 | create user os identified by os |
19 | default tablespace os_data |
20 | temporary tablespace os_temp; |
21 |
22 | -- 给用户授予权限 |
23 | grant connect ,resource to os; |
24 |
25 | -- 删除表空间 |
26 | drop tablespace os_data including contents and datafiles; |