Jump to content
reem-akk

to what extent we can grant quota on users tablespace

Recommended Posts

hi guys

i have very important question :

i create user and grant you by(sys administrator) connect role and create table privilige and not resource role so we have to grant it quota on users tablespace, so to what extent we can grant quota for user account???

in other words how size every body can have for his datafiles????

Share this post


Link to post
Share on other sites
Hi Reem,

 

Oracle is a shared data repository, it is never segmented by user name!

 

It is a bad idea to use quotas, IMHO, because you never want a transaction to fail for a lack of space:

 

Please read:

 

http://www.dba-oracle.com/concepts/unlimited_tablespace.htm

 

Good luck!

 

thanks very much

I agree your answer but I have been meaning ,what is the bigger size in complete database?? is it 4G in oracle 10g???

as you told me that It is a bad idea to use quotas but quotas idea is present so when should we use?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×