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:

• The CREATE DATABANK clause defines the databank name.
• The optional FILESIZE clause is used to specify the initial file size (it will be dynamically extended as space is required). If the clause is omitted, an initial file size of 2000 kB is assumed. The optional GOALSIZE, MAXSIZE and MINSIZE attributes are used to manage the file size, see Mimer SQL Reference Manual, CREATE DATABANK.
• The optional FILE clause defines the file where the databank is to be stored (the form of the filename follows the operating system file naming conventions). If the FILE clause is omitted, the file is created in the database home directory with the same name as databank-name.
• The optional OPTION clause defines the transaction handling and logging option, see Logging Transactions. If the OPTION clause is omitted, the TRANSACTION option is assumed.

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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se