| Tablespaces and Users [message #52589] |
Tue, 30 July 2002 21:36  |
Srividya
Messages: 4
Registered: May 2002
|
Junior Member |
|
|
|
How are tablespace and user schema related? Can a oracle user instance have multiple tablespaces?
|
|
|
|
| Re: Tablespaces and Users [message #52591 is a reply to message #52589] |
Tue, 30 July 2002 22:25  |
Vikas Gupta
Messages: 115
Registered: February 2002
|
Senior Member |
|
|
Relation ship of USERS to Tablespaces is MANY to MANY.
Meaning more then one USER can store tables in the
same tablespace and ONE USER can store tables in Different tablespaces. You can control that by giving a USER QUOTA on different tablespaces.
Regards,
Vikas.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
