Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Allocating more space for database

977650Feb 22 2013 — edited Feb 22 2013
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2013
Added on Feb 22 2013
5 comments
1,209 views