--创建表空间
CREATE TABLESPACE "TBS_TEST_01" DATAFILE
'TBS_TEST_01_1.DBF' SIZE 128 AUTOEXTEND ON NEXT 2048,
'TBS_TEST_01_2.DBF' SIZE 128 AUTOEXTEND ON NEXT 2048;
CREATE TABLESPACE "IDX_TEST_01" DATAFILE
'IDX_TEST_01_1.DBF' SIZE 128 AUTOEXTEND ON NEXT 2048,
'IDX_TEST_01_2.DBF' SIZE 128 AUTOEXTEND ON NEXT 2048;
--创建用户/指定数据表空间/指定索引表空间
CREATE USER "TEST_01" IDENTIFIED BY "Admin@1234" DEFAULT TABLESPACE "TBS_TEST_01" DEFAULT INDEX TABLESPACE "IDX_TEST_01";
--赋予权限
GRANT "PUBLIC","RESOURCE","VTI","SOI","SVI" TO "TEST_01";
--取消用户限制
ALTER USER "TEST_01" LIMIT FAILED_LOGIN_ATTEMPS UNLIMITED, PASSWORD_LOCK_TIME UNLIMITED, PASSWORD_GRACE_TIME UNLIMITED;
默认存放路径为
select para_value from v$dm_ini where para_name ='SYSTEM_PATH';
一般为指定路径没有权限,数据库默认为dmdba普通用户运行,对于系统目录例如root等是没有权限的,可以参考以下语句创建表空间和用户
默认存放路径为