Databanks may be defined with the
READ ONLYoptions which determine transaction handling and logging behavior, as follows:
- READ ONLY
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 SET FILE 'dev.dbf', FILESIZE 50 M, OPTION LOG; SQL> CREATE IDENT DEVUSER AS USER USING 'devuser'; SQL> GRANT TABLE ON DEVELOP TO DEVUSER; SQL> CREATE IDENT JIM AS USER; SQL> ALTER IDENT JIM ADD OS_USER 'JIM'; SQL> ALTER IDENT JIM ADD OS_USER 'JAMES'; SQL> GRANT TABLE ON DEVELOP TO JIM;
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40