1. Scripting Reference for Oracle Essbase
  2. MaxL
  3. MaxL Statements (Aggregate Storage)
  4. Create Database (Aggregate Storage)

Create Database (Aggregate Storage)

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

Click here for non-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.

The syntax for creating an aggregate storage database is the same as for creating a block storage database. You must create an aggregate storage database as part of an aggregate storage application.

Permission required: Application Manager.

Syntax


Description of credb_as.gif follows
Description of the illustration credb_as.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.

comment

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

Notes

  • You cannot create an aggregate storage database as a copy of another aggregate storage database. Only one aggregate storage database is allowed per application.

  • You cannot copy a block storage database to an aggregate storage database. For an example of how to create an aggregate storage application and database based on a block storage application and database, see Creating an Aggregate Storage Sample Using MaxL.

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.