oracle创建表空间和用户的语句
--创建临时表空间create temporary tablespace test_temptempfile 'C:\test_temp1.dbf'size 10m autoextend on next 10m maxsize 100m extent management local;--创建表空间create tablespace test_datalogging datafile 'C:\test_data1.dbf' size 10m autoextend on next 10m maxsize 100m extent management local; --删除临时表空间 包含内容和物理文件--drop tablespace test_temp including contents and datafiles;--删除临时表空间 包含内容和物理文件--drop tablespace test_data including contents and datafiles;--创建用户并指定表空间和临时表空间create user user001 identified by 123456default tablespace test_datatemporary tablespace test_temp;--授予用户权限grant connect ,resource to user001;
页:
[1]