1、oracle 7.3
2、用户向表A插入数据时,报ORA-01536;space quota exceeded for tablespace 'USERS'
3、system/manager 进入pb ,可以插入
4、表空间、数据文件、索引全部设为---无限增长
5、alter user USERNAME quota 100m on users 后,不起作用。
2、用户向表A插入数据时,报ORA-01536;space quota exceeded for tablespace 'USERS'
3、system/manager 进入pb ,可以插入
4、表空间、数据文件、索引全部设为---无限增长
5、alter user USERNAME quota 100m on users 后,不起作用。
ALTER USER usera QUOTA UNLIMITED ON users;
不信你alter user USERNAME quota 1000m on users就可以了。
ALTER USER usera QUOTA UNLIMITED ON users;
这种方法不起作用。
2、不知道 alter user USERNAME quota 1000m on users 如何。3、删除该表大约1/10之一记录后,可以用了,但十天后又出现该故障了。有什么办法呢?
ORA-01536 space quota exceeded for tablespace 'string'Cause: The space quota for the segment owner in the tablespace has been exhausted and the operation attempted the creation of a new segment extent in the tablespace.Action: Either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner.