1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Name a tablespace automatically created when you create a
database.

Question Posted / md azhar alvi

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


Please Help Members By Posting Answers For Below Questions

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

555

What types of replication are supported in sql server? : sql server DBA

601

what is a user-defined lock?

587

What are the different types of indexes available in sql server? : sql server DBA

573

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1555




what is grd?

636

what is logical system in sap basis

1135

how does an oracle clusterware manage crs resources?

569

What are the different sql server versions you have worked on? : sql server DBA

543

Can you redefine a table online?

669

what are the types of connection load-balancing?

564

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1656

What the different types of replication and why are they used? : sql server DBA

559

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1541

what functionality does oracle provide to secure sensitive information?

554