What is default tablespace ?
Answers were Sorted based on User's Feedback
Answer / pavan_1981
its the tablespace in to which the objects created by a
user go.default tablespace can alloted to a user while
creating he user or can also be changed after creating the
user.
the default table space of a user is system tablespace
unless mentioned specfically while creating the user.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dinu
default tablespace is a logical storage structure where the
datafile stores...every user should must have default
tablespace
Is This Answer Correct ? | 0 Yes | 0 No |
What is a profile ?
What is snapshots ?
What are the database administrators utilities avaliable ?
what is meant by physical order and logical order in clustered index and non clustered index.
What are the different Levels of Auditing ?
What are the responsibilities of a Database Administrator ?
What dynamic data replication ?
What is Statement Auditing ?
What are the various type of snapshots ?
How will you enforce security using stored procedures ?
What are the use of Roles ?
What are the system resources that can be controlled through Profile ?