Interested to Buy Any Domain ? << Click Here >> for more details...
Name a tablespace automatically created when you create a
database.
- 5 Answers
- 12580 Views
- I also Faced
- E-Mail Answers
Answer Posted / md azhar alvi
At the time of database creation SYSTEM.DBF AND SYSAUX.DBF tablespaces are created.
SYSTEM.DBF contains the data dictionary views and objects which in owned by sysdba.
in oracle 11g if we are omitting the creation of sysaux.dbf tablespace oracle will automatically create the sysaux.dbf tablespace.
sysaux.dbf contain repository values of oracle tools.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
how to restore files with rman?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is asm?
What is a system database and what is a user database? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Where would you look for errors from the database engine?
What the different topologies in which replication can be configured? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what do you understand by flashback feature of oracle?
What is the difference between clustered and non-clustered index? : sql server DBA
What is dcl? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
