InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Why Is It Needed To Create A Default Tablespace For Every User? |
|
Answer» If we dont assign a default tablespace System tablespace becomes the default tablespace. If a user creates a very LARGE object in the System table space, they MIGHT take up all the space in it and make it IMPOSSIBLE for the SYS superuser to create any new OBJECTS in it, causing the database to come to a grinding halt. This is the main reason why we should always create a default tablespace for every user. If we dont assign a default tablespace System tablespace becomes the default tablespace. If a user creates a very large object in the System table space, they might take up all the space in it and make it impossible for the SYS superuser to create any new objects in it, causing the database to come to a grinding halt. This is the main reason why we should always create a default tablespace for every user. |
|