Creating and Configuring an Oracle Database

After you plan your database, you can create the database with a graphical tool or a SQL command.

iot internet of things training courses malaysia

• About Creating an Oracle Database
  You typically create a database during Oracle Database software installation. However, you can also create a database after installation.
• Considerations Before Creating the Database
  Database creation prepares several operating system files to work together as an Oracle Database. You only need to create a database once, regardless of how many data files it has or how many instances access it. You can create a database to erase information in an existing database and create a new database with the same name and physical structure.

IBM websphere training courses malaysia

• Creating a Database with DBCA
  Oracle Database Configuration Assistant (DBCA) is a tool for creating and configuring an Oracle database.
• Creating a Database with the CREATE DATABASE Statement
  Using the CREATE DATABASE SQL statement is a more manual approach to creating a database than using Oracle Database Configuration Assistant (DBCA). One advantage of using this statement over using DBCA is that you can create databases from within scripts.
• 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.

IBM lotus notes domino datastage training courses malaysia

• Specifying Initialization Parameters
  You can add or edit basic initialization parameters before you create your new database.
• Managing Initialization Parameters Using a Server Parameter File
  Initialization parameters for the Oracle Database have traditionally been stored in a text initialization parameter file. For better manageability, you can choose to maintain initialization parameters in a binary server parameter file that is persistent across database startup and shutdown.
• Managing Application Workloads with Database Services
  A database service is a named representation of one or more database instances. Services enable you to group database workloads and route a particular work request to an appropriate instance.
• Considerations After Creating a Database
  After you create a database the instance is left running, and the database is open and available for normal database use. You may want to perform specific actions after creating a database.
• Cloning a Database
  This section describes various methods of cloning an Oracle database.
• Dropping a Database
  Dropping a database involves removing its data files, online redo logs, control files, and initialization parameter files.
• Database Data Dictionary Views
  You can query data dictionary views for information about your database content and structure.
• Database Configuration Assistant Command Reference for Silent Mode
  This section provides detailed information about the syntax and options for the Database Configuration Assistant (DBCA) silent mode commands.

VMware certification training courses malaysia