473,320 Members | 1,823 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

quota

Hi all,
How to drop quota's in the oracle..


thanks
Michael
Sep 3 '07 #1
3 4196
amitpatel66
2,367 Expert 2GB
Please provide more information/script that you have tried to work on?
Sep 3 '07 #2
Hi all,
How to drop quota's in the oracle..


thanks
Michael
pls explain clearly, what do u want..
Sep 4 '07 #3
See,

To knw on which Tablespace, user had the permissions:

Eg.
Select tablespace_name from dba_ts_quotas where username=<username>;

and if you want that user shud not have quota over those tablespace, you can simply alter that user:

Eg.
Alter user <username> quota 0 on <tablespace_name>;

I hope that solves your purpose, If I have assumed you correctly :D
Sep 5 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Bart Simpson | last post by:
Hi, I'm testing to control Windows disk quota by PythonWin on win2003 and winXP. But ther is some problem.. This is the test code: import win32com.client
1
by: 3legs | last post by:
Dear all, My company is a web hosting company that provides ASP hosting, but recently I encountered a difficulty that is people are trying to upload with ASP and thus the owner of the uploaded...
0
by: Andrew Crook | last post by:
does MYSQL have a quota built into it! I need it limit the size of each database AndiC
1
by: Rajesh Kapur | last post by:
Hello, Is there a way to assign a limit on the size of a specific database? For example database A can take up no more than 500 MB. One of my databases can potentially grow without any bounds...
4
by: Per | last post by:
I am doing a Natural Language processing project for academic use, I think google's rich retrieval information and query-segment might be of help, I downloaded google api, but there is query...
1
by: lawrence k | last post by:
I've a site where I've just installed a new version of phpMyAdmin (version 2.8.1). I can't get it to work. I'm getting this error: Warning: session_write_close(): write failed: Disk quota...
0
by: microtom | last post by:
Hi chaps I found that the DiskQuotaTypeLibary (dskquota.dll) offers an easy way to get disk quota information for an NTFS volume. Does anybody know of how to get this information from a unix...
3
by: =?Utf-8?B?bWFkY3lyeWw=?= | last post by:
I am currently in an educational enviroment and have decided to limit student folders to 75mb in size using disk quotas. this has now been implemented but quite a few folders are showing up in disk...
4
by: Dilip | last post by:
Hi I am using the following WMI code to watch for the termination of a particular process. This code is running under Windows Vista. public void WaitForDeath() { using (AutoResetEvent...
1
by: Greg99 | last post by:
Hello. I need to find the available space for a given path (could be a network path) with a quota applied, but when I use the following code, it gives me the available space on the entire drive. ...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.