OraFAQ Forum: Server Administration » Can I give Schema's their own Individual Tablespace?

Home » RDBMS Server » Server Administration » Can I give Schema's their own Individual Tablespace?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can I give Schema's their own Individual Tablespace? [message #242574]

Mon, 04 June 2007 02:56

t.summerfield
Messages: 39
Registered: March 2007
Location: UK

Member

Oracle 9i on win2003

I have a database called dev_zeus which contains various schema's. The schemas are in groups of 5 each with their own prefixs

e.g.

ora1ControlDB
ora1DB
ora1LearningDB
ora1ResourceDB
ora1SRMDB

ora2ControlDB
ora2DB
ora2LearningDB
ora2ResourceDB
ora2SRMDB

The whole database uses 1 set of tablespaces. My question is; is it possible to give each group of schemas their own individual tablespace, and if so how?

Thanks in advance for any thoughts or suggestions.

Regards
Toby

Report message to a moderator