本文将介绍在oracle中如何创建表空间和用户,下面通过举例来说明:
创建临时表空间语法如下:
create temporary tablespace test
tempfile 'D:\oracle\oradata\test.dbf'
size 50m autoextend on
next
50m maxsize 20480m extent management local
创建数据表空间语法:
create tablespace test_data
logging
datafile 'D:\oracle\oradata\test_data.dbf'
size 50m autoextend on
next
50m maxsize 20480m extent management local
创建用户:
create userusername
identified by password
default tablespace test_data
temporary tablespace test
给用户授权:
grant connect,resource,dba to username
删除表空间:
drop tablespace test_data including contents and datafiles
删除用户:
drop user username