1. Scripting Reference for Oracle Essbase
  2. MaxL
  3. MaxL Statements
  4. MaxL Statement Reference
  5. Create Database

Create Database

The MaxL create database statement helps you create or re-create an Essbase cube, optionally as a copy of another on the same server.

Click here for aggregate storage version

See DBS-NAME for information on the maximum length of and special characters that are allowed in a database name. Database names are not case-sensitive.

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

Syntax


Description of credb.gif follows
Description of the illustration credb.gif

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

Keywords

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 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.