Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Databank Options


Databanks may be defined with the LOG, TRANSACTION, WORK, or READ ONLY options which determine transaction handling and logging behavior, as follows:

Note: Operations performed on databanks with the TRANSACTION or WORK option cannot be restored in the event of system failure, see Backing-up and Restoring Data.

If a databank is dropped from the database, the tables stored in the databank are also dropped and the physical databank file is deleted from disk.

Creating Idents and a Databank - an Example

In the following example, a databank and two users (idents) are created. The idents are then given the authority to create tables within the databank:

 SQL> CREATE DATABANK DEVELOP OF 1000 PAGES
             IN 'dev.dbf' WITH LOG OPTION;
 SQL> CREATE IDENT DEVUSER AS USER USING 'devuser';
 SQL> CREATE IDENT JOE AS OS_USER;
 SQL> GRANT TABLE ON DEVELOP TO DEVUSER;
 SQL> GRANT TABLE ON DEVELOP TO JOE;

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