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 different between view and sequence?
What is Tablespace Quota ?
What is the use of ANALYZE command ?
What are roles ? How can we implement roles ?
What are the options available to refresh snapshots ?
What are the minimum parameters should exist in the parameter file (init.ora) ?
What are the database administrators utilities avaliable ?
What are Roles ?
What dynamic data replication ?
What is a trace file and how is it created ?
What is a profile ?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?