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 would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

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

0 Answers  

Explain what partitioning is and what its benefit is.

2 Answers  

What is checkpoint?

3 Answers   Accenture,

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

How to make a replica of existing oracle server to another server?

3 Answers  

Hot backup procedure?

2 Answers  

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

Datapump backup steps?

1 Answers  

How would you determine the time zone under which a database was operating?

2 Answers