Allocating more space for database
977650Feb 22 2013 — edited Feb 22 2013Hi,
I have a requirement to ask dba to allocate more space to my oracle database(11g). i know to do this he just have to do
"alter tablespace tspc1 add data file 'data01.ora'"
but my condition is that there are many schemas in same database, what i want him to do is to allocate more space to my schema alone and distribute rest space to all others. lets say current db has 4tb space, i want to add 2tb space more, i want to allocate my schema alone 1tb and rest all schemas 1 tb (total 2 tb)
is this possible? if so please let me know the way out.
Thanks