If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Right now, INDX is about 35G and ERPDATA is about same size.
My task here is to break INDX and ERPDATA tablespace into several smaller tablespace based on each companyid in our ERP system.
Someting like,
INDX105, INDX206, INDX100, INDX...
DATA105, DATA206, DATA100, DATA...
(105,206,100 are represented each companyID in ERP)

Currently, I have only one user, ERP_USR in Oracle database and this user owns everything (beside system owned objects).

When users connect to database, they are using ERP_USR, one and the only one user in Oracle. How do I make company 100 users to work on INDX100 and DATA100 tablespaces. In other words, user login to database as ERP_USR and based on different companyid they are working on, data need to be stored in companyid-related tablespace. How can I do this? Please help.