unable to create a tablespace under user scott despite of many privileges
Hi,
I use user scott to test a rdf database using oracle 11.2.0.2 contained in oracle developer days in my oracle linux enterprise guest system. However, I am unable to create a tablespace under scott. The error message says insufficient privilege. Actually, I granted all privilege in Roles, System Privileges, Object Privileges to scott in the OEM panel. I also granted resource, create session, create table, unlimited tablespace to scott in sqlplus as well. However, I am still unable to create the tablespace. The command I used for creating tablespace is below:
create tablespace rdf_tblspace
datafile '\home\oracle\app\oracle\oradata\rdf_tblspace.dat' size 14m reuse
autoextend on next 10m maxsize unlimited
segment space management auto;
Error at Command Line:1 Column:1
Error report:
SQL Error: ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
Any suggestions will be much appreciated. Thanks a lot in advance.