Create Database

Click here for aggregate storage version

Create or re-create a regular or currency database. Optionally create the database as a copy of another database on the same system. DBS-NAME must consist of 8 or fewer characters. Avoid spaces and special characters when naming applications and databases.

Permission required: Application Manager. To copy a database, Manager permission on the source database is additionally required.

Syntax

Syntax diagram for create database.DBS-NAMECOMMENT-STRING

Use create database to create a database in the following ways:

KeywordDescription

create database

Create a new database. Database names are not case-sensitive.

create or replace database

Create a database, or replace an existing database of the same name. Database names are not case-sensitive.

create database using non_unique_members

Create a database that supports the use of duplicate member names. Once you have created a database with a duplicate member outline, you cannot convert it back to a unique member outline.

For more information about duplicate member names, see the Oracle Essbase Database Administrator's Guide chapter titled "Creating and Working With Duplicate Member Outlines."

create database as

Create a database as a copy of another database. Database names are not case-sensitive.

create currency database

Create or replace a database for currency conversion. Linking a currency database to a main database enables you to convert currency values in a database from one currency into another currency.

comment

Create a database description (optional). The description can contain up to 80 characters.

Example

create or replace database Sample.Basic comment 'This is a test.';

Creates a database called Basic within the Sample application. If a database named Basic within the Sample application already exists, it is overwritten.

create database Sample.New as Sample.Basic;

Creates a database called New within the Sample application that is a copy of the database Basic within the Sample application.

create currency database Sample.Interntl;

Creates a currency database called Interntl within the Sample application.