Interested to Buy Any Domain ? << Click Here >> for more details...
Name a tablespace automatically created when you create a
database.
- 5 Answers
- 12607 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
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you schedule a job in database?
How would you go about verifying the network name that the local_listener is currently using?
What happens on checkpoint? : sql server DBA
what is the role of dip user in our database?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
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?
What is fill factor? : sql server DBA
What is a system database and what is a user database? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is logical system in sap basis
Explain materialized views and how they are used.
