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 are roles ? How can we implement roles ?
What are the use of Roles ?
What is Auditing ?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
What are the benefits of distributed options in databases ?
What is snapshots ?
What are the different Levels of Auditing ?
what is meant by physical order and logical order in clustered index and non clustered index.
What dynamic data replication ?
What are the various type of snapshots ?
How can you Enforce Refrencial Integrity in snapshots ?
What is default tablespace ?