Hi All,

I have been assigned to reorg our production database and so far I have no idea how to get it done. Any input will be useful.

Oracle 8.06.1/NT-sp6, DB about 75G.

Tablespace
NAME
------------------------------
SYSTEM
RBS
USR
TEMPORARY
INDX
ERPDATA

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.