Re: HELP!!!...DESIGNER 2000 PROBLEMS

In article <1996Nov12.144659.10563_at_enterprise.rdd.lmsc.lockheed.com>, Robert Perry <perry_at_mezzrtm.lasc.lockheed.com> writes
>
>My users are experiencing the following problems & I cannot seem to find a
>solution(even working with Oracle support). I hope someone outthere can
>help.
>
> 1)When attempting to Reverse Engineer data from a remote database these
> errors are encountered:
> ORA-01536 space quota exceeded for tablespace 'DES2_I'
> ORA-06512 at "DESMGR.CITSDD_ELEMENTS", line 452
> ORA-06512 at "DESMGR.CITSDD_ELEMENTS", line 380
> ORA-06512 at line 2
> ORA-04088 error during e"'1+_>
>
> My user is able to create a database within the instance I created for
> Designer 2000 (repository) and reverse engineer tables & tablespaces
> into this database until he reaches what appears to be the storage limit.
> I have added generous amounts of space to the instance tablespaces but
> the errors still persist.

The user may have a limited space quota on the tablespace (or possibly even no quota at all), so adding space won't help. Have a look in the view DBA_TS_QUOTAS (or something like that).

Or just try

'alter user xxxx quota unlimited on des2_i';

-- 
Jim Smith