Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

User quota on tablespace

2670775Jul 28 2016 — edited Jul 28 2016

I have a user originally have no limit quota on tablespace USERS

then this user insert about 7MB data. After this user delete all the data

and I set quota to 5MB for this user on USERS

And in dba_ts_quotas; the bytes column is still 7MB which is larger than 5MB quota.

Are there anyway to reset it ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2016

Added on Jul 28 2016

#general-database-discussions

6 comments

1,269 views