Create Database (Aggregate Storage)
Click here for non-aggregate storage version
Create or re-create a database for an aggregate storage application.
The syntax for creating an aggregate storage database is the same as for creating a block storage database, except that the currency database option is not supported. You must create an aggregate storage database as part of an aggregate storage application.
Permission required: Application Manager.
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." |
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.