| ora-01536 [message #63372] |
Thu, 30 September 2004 02:26  |
andy
Messages: 92
Registered: December 1999
|
Member |
|
|
i have an ora-01536 error
anyone know how i can find the user who has reached their tablespace quota, what the tablespace name is and how i can increase it?
thanks
|
|
|
|
| Re: ora-01536 [message #63375 is a reply to message #63372] |
Thu, 30 September 2004 03:12  |
Deepak Panda
Messages: 24
Registered: May 2004
|
Junior Member |
|
|
Try This............. and let me know.....
select TABLESPACE_NAME,username, (bytes/(1024*1024))-(MAX_BYTES/(1024*1024)) UNUSED_MB from DBA_TS_QUOTAS;
|
|
|
|
| Re: ora-01536 [message #63378 is a reply to message #63375] |
Thu, 30 September 2004 03:31 |
Deepak Panda
Messages: 24
Registered: May 2004
|
Junior Member |
|
|
Use this one instead.......
select TABLESPACE_NAME,username,decode(MAX_BYTES,-1,'UNLIMITED',MAX_BYTES) QUOTA,bytes USED from DBA_TS_QUOTAS;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
