974647 wrote:What makes the DBA hesitant?
yes you are right that none of schemas have been given unlimited tablespace. but still dba is bit hesitant to do this thing.
can you tell me any scenario where such allocation(1 tb to my tablespace and rest to other) will be not recomended or not possible?Talking about what is "recommended" will depend heavily on exactly what the business problem you are trying to solve is (not what technical approach you have decided to take). What is the relationship between the various schemas? Why are they using a single tablespace?
Also if possible can you please give me the syntax to do so?
ALTER USER your_schema_name QUOTA <<existing quota + 1 TB>> ON tablespace_name ALTER USER some_other_schema QUOTA <<existing quota + 1 TB>> ON tablespace_name
974647 wrote:Why from a business standpoint do the various users share that tablespace? Why from a business standpoint is it important that the newly allocated space only goes to one user?
may be i should rephrase my question. actually the tablespace that i own is shared by many other 'owners' but i want the datasize just for me to be increased.
now when i ask him to just increase quota for 'myself', he is hesitant.Why is he hesitant? I asked this earlier. Without understanding the business problem, it's hard to offer anything more.
Can this be done? and if so can you plz provide me with syntax?It can. I provided the syntax in my last post. Is there some problem with what I posted?