Answer / ramesh

System Tablespace is Created when a New oracle Database is
created.
It,s Not-> while Creation of Tablespace
However ,Ensure No user objects created in System Tablespace

Cheers,
Ramesh

Answer / deepak

system tablespace

Answer / nagarani k

system and sysaux tablespaces are automatically created in
oracle 10gR2 when database created

Answer / guest

It is SYSTEM tablespace which get automatically get created
whenever we create any tablespace


Regards
Abhinav Phadnis

Answer / 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.

What view would you use to determine free space in a tablespace?

3 Answers  

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

What is a correlated sub-query? : sql server DBA

0 Answers  

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

How would you go about generating an EXPLAIN plan?

2 Answers  

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

what is incremental checkpoint?

1 Answers   CTS,

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

What are the commands used in dcl? : sql server DBA

0 Answers  

What the different topologies in which replication can be configured? : sql server DBA

0 Answers