enough space, unlimited tablespace ,why faces the error ORA-01536

Yong Huang

原帖由 magic007 于 2010-5-30 22:47 发表
数据插入是用的存储过程还是在会话上直接执行的SQL？

I tested in both 9.2.0.6 and 10.2.0.4 creating a table in a procedure or PL/SQL anonymous block with no quota on the tablespace but with unlimited tablespace privilege. The user *can* create the table fine.

create user u identified by u;
grant create table, create session, unlimited tablespace, create procedure to u;

conn u/u
exec execute immediate 'create table t (x int)'
drop table t;
create procedure p as begin execute immediate 'create table t (x int)'; end;
/
exec p
drop table t;

I suspect his case is something more basic. A user error or something. If he can reproduce the case in SQL*Plus, it's worth more research.

Yong Huang

bnhhh

首先感谢版主，无论现在这个问题原因如何，你能在凌晨一点还回复这个帖子，在此表示感谢。

bnhhh

版主，原因找到了，表所属用户和表里面索引所属用户不一致，而报错的那个表空间就是索引所属表空间，但是新的问题又出现了。
生产库上面是在表所属用户上面进行了配额分配解决了问题，可是我做测试给表用户加配额还是报那种错误。很郁闷！！！