| User, Constraints and tablespaces [message #116804] |
Fri, 22 April 2005 06:06  |
m_scandroglio
Messages: 26
Registered: March 2005
|
Junior Member |
|
|
Hi all!
There is a "dispute" whether is correct or not to let the SYSTEM tablespace (oracle default) during the creation of a user and the constraints (pk) of his tables.
There's any contro-indications?
Thanks!
milena
|
|
|
|
| Re: User, Constraints and tablespaces [message #116848 is a reply to message #116804] |
Fri, 22 April 2005 09:05  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
DO NOT use the system tablespace for anything. Period.
Make your own tablespace for user data and indexes (constraints), and make another tablespace for temp data. If your version supports it, make those the database defaults. If not, make those the user level defaults for every user you create.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
