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.

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  

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

Explain CREATE DATABASE syntax?

2 Answers  

What would you do with an "in-doubt" distributed transaction?

0 Answers  

Datapump backup steps?

1 Answers  

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

what is the role of dip user in our database?

0 Answers  

How do you add a data file to a tablespace?

3 Answers  

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

How would you extract DDL of a table without using a GUI tool?

0 Answers