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

Report message to a moderator

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: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter user ... defaut tablespace ...

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:31:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.