Specifying CREATE DATABASE Statement Clauses

When you execute a CREATE DATABASE statement, Oracle Database performs several operations. The actual operations performed depend on the clauses that you specify in the CREATE DATABASE statement and the initialization parameters that you have set.

oracle Siebel crm training courses malaysia

• About CREATE DATABASE Statement Clauses
  You can use the CREATE DATABASE clauses to simplify the creation and management of your database.
• Protecting Your Database: Specifying Passwords for Users SYS and SYSTEM
  To protect your database, specify passwords for users SYS and SYSTEM.

oracle peoplesoft training courses malaysia

• Creating a Locally Managed SYSTEM Tablespace
  During database creation, create a locally managed SYSTEM tablespace. A locally managed tablespace uses a bitmap stored in each data file to manage the extents.
• Specify Data File Attributes for the SYSAUX Tablespace
  The SYSAUX tablespace is created by default, but you can specify its data file attributes during database creation.
• Using Automatic Undo Management: Creating an Undo Tablespace
  Automatic undo management uses an undo tablespace.

oracle Linux administration training courses malaysia

• Creating a Default Permanent Tablespace
  Oracle strongly recommends that you create a default permanent tablespace. Oracle Database assigns to this tablespace any non-SYSTEM users for whom you do not explicitly specify a different permanent tablespace.
• Creating a Default Temporary Tablespace
  When you create a default temporary tablespace, Oracle Database assigns it as the temporary tablespace for users who are not explicitly assigned a temporary tablespace.
• Specifying Oracle Managed Files at Database Creation
  You can minimize the number of clauses and parameters that you specify in your CREATE DATABASE statement by using the Oracle Managed Files feature.
• Supporting Bigfile Tablespaces During Database Creation
  Oracle Database simplifies management of tablespaces and enables support for extremely large databases by letting you create bigfile tablespaces.
• Specifying the Database Time Zone and Time Zone File
  Oracle Database datetime and interval data types and time zone support make it possible to store consistent information about the time of events and transactions.
• Specifying FORCE LOGGING Mode
  Some data definition language statements (such as CREATE TABLE) allow the NOLOGGING clause, which causes some database operations not to generate redo records in the database redo log. The NOLOGGING setting can speed up operations that can be easily recovered outside of the database recovery mechanisms, but it can negatively affect media recovery and standby databases.

oracle e business suite training courses malaysia