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 |
How can you enable automatic archiving ?
What are the benefits of distributed options in databases ?
What are the responsibilities of a Database Administrator ?
What are Roles ?
What are the use of Roles ?
When will the data in the snapshot log be used ?
How to prevent unauthorized use of privileges granted to a Role ?
What is the use of ANALYZE command ?
What is a trace file and how is it created ?
what is snapshot log ?
How will you enforce security using stored procedures ?
What is a profile ?