Ways to create an Oracle Database - Oracle DBA

Discussion

• Nirja Shah   -Posted on 25 Aug 15
  -You can create a database in three ways:
  
  -Use the Database Configuration Assistant (DBCA) - DBCA can be launched by the Oracle Universal Installer, depending upon the type of install that you select, and provides a graphical user interface (GUI) that guides you through the creation of a database.
  -You can also launch DBCA as a standalone tool at any time after Oracle Database installation to create or make a copy (clone) of a database
  
  -Use the CREATE DATABASE statement - You can use the CREATE DATABASE SQL statement to create a database.
  -If you do so, you must complete additional actions before you have an operational database.
  -These actions include creating users and temporary tablespaces, building views of the data dictionary tables, and installing Oracle built-in packages.
  -These actions can be performed by executing prepared scripts, many of which are supplied for you.
  
  -Upgrade an existing database - If you are already using a earlier release of Oracle Database, database creation is required only if you want an entirely new database.
  -You can upgrade your existing Oracle Database and use it with the new release of the database software.

➨ Post your comment / Share knowledge