搂住把自己的sql语句给贴出来分析下来哦 看下这2个: SQL> create user test identified by test default tablespace test quota 50k on temp; 用户已创建 22:46:18 SQL> create user test identified by test default tablespace test quota 50k on undotbs; create user gigi identified by gigi default tablespace ning quota 50k on undotbs* ERROR 位于第 1 行: ORA-30041: 无法在表空间上授予限额 create user HDAPP_2 identified by abc default tablespace HDAPP temporary tablespace TEMP quota unlimited on HDAPP quota unlimited on TEMP; 出现如下错误: ORA-30041: 无法在表空间上授予限额 ORA-06512: 在 line 6 查了一下,发现是: ORA-30041: Cannot grant quota on the tablespace Cause: User tried to grant quota on an undo or temporary tablespace Action: Check the tablespace name and reissue the command
看下这2个:
SQL> create user test identified by test default tablespace test quota
50k on temp;
用户已创建
22:46:18 SQL> create user test identified by test default tablespace test quota
50k on undotbs;
create user gigi identified by gigi default tablespace ning quota 50k on undotbs*
ERROR 位于第 1 行:
ORA-30041: 无法在表空间上授予限额
create user HDAPP_2 identified by abc default tablespace HDAPP temporary tablespace TEMP
quota unlimited on HDAPP
quota unlimited on TEMP;
出现如下错误:
ORA-30041: 无法在表空间上授予限额
ORA-06512: 在 line 6
查了一下,发现是:
ORA-30041: Cannot grant quota on the tablespace
Cause: User tried to grant quota on an undo or temporary tablespace
Action: Check the tablespace name and reissue the command
在oracle 8i,oracle 9i,oracle 10.1.0.2上面都没问题我感觉在创建用户的时候不要使用临时表空间了,用自己建的表空间试下勒
然后再建立