Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Creating Databanks


A databank is the file where tables and sequences are stored. A Mimer SQL database may contain any number of databanks.

Create Databank Statement

The statement for creating a databank has the general form:



Examples

Create a databank called MIMER_BLOBS with the default parameters:
Note: The default parameters are with TRANSACTION option and size 2000 kB. This databank is created in a file called 'mimer_blobs.dbf'
 CREATE DATABANK mimer_blobs;
Create the MIMER_STORE databank with LOG option, allocate 1200 MB for it, and store it in a file called 'mimer_store.dbf':
 CREATE DATABANK mimer_store SET FILESIZE 1200 M,
                                 FILE 'mimer_store.dbf',
                                 OPTION LOG;
 

At this point, the databank is empty.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX