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
Use create database to create a database in the following ways:
Keyword | Description |
---|---|
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.