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 the minimum parameters should exist in the parameter file (init.ora) ?
What is Statement Auditing ?
How can we reduce the network traffic ?
What is Tablespace Quota ?
Differentiate simple and complex, snapshots ?
What is user Account in Oracle database ?
What are the benefits of distributed options in databases ?
What are roles ? How can we implement roles ?
When will the data in the snapshot log be used ?
What are the responsibilities of a Database Administrator ?
How will you enforce security using stored procedures ?
What is Object Auditing ?