-
ORA-01536 error
Hello all..
we have multiple users trying to insert data into Oracle 9.2 DB.
All users are assigned 'USERS' TBS as their Default TBS.
one user cannot load some data into one table. its giving him,
"ORA-01536 Space Quota Exceeded for Tablespace " USERS""
any ideas ?...
these are locally managed TBS and under Auto allocation.
Thanks
ron
-
That means the user who is getting this error just does not have enough 'quota' on USERS Tablespace. Assign him enough/proper Quota on User Tablespace to resolve this error. Refer to Table USER_TS_QUOTAS.
HTH.
-- Dilip
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|