Home » RDBMS Server » Server Administration » Can I give Schema's their own Individual Tablespace?
Can I give Schema's their own Individual Tablespace? [message #242574] Mon, 04 June 2007 02:56 Go to next message
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
Re: Can I give Schema's their own Individual Tablespace? [message #242614 is a reply to message #242574] Mon, 04 June 2007 06:11 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter user ... defaut tablespace ...

Regards
Michel
Previous Topic: ORA-27101: shared memory realm does not exist
Next Topic: 2 profiles for oracle user on solaris
Goto Forum:
  


Current Time: Fri Dec 02 22:51:35 CST 2016

Total time taken to generate the page: 0.04982 seconds