Create the Artifactory Oracle Database

JFrog Installation & Setup Documentation

Content Type
Installation & Setup

You can choose between the following configurations to set up your Oracle Database.

  • DB-Filesystem

    This configuration stores metadata in Oracle Database and artifact binary data is stored on the file system (under $JFROG_HOME/artifactory/var/data/artifactory/filestore). This option has the advantage of being very lightweight on the Oracle database.

  • Full DB

    This configuration stores both metadata and BLOBs in Oracle Database. This option requires minimal maintenance and allows you to rely solely on Oracle for failover and backup procedures, since all data is in the database.

    When using this option, make sure you have created a table space big enough to accommodate your binaries.

Artifactory privileges

Artifactory creates all tables automatically first time it is run. When performing a software upgrade, Artifactory may have to alter tables and indices, so make sure you grant the configured connection the appropriate user permissions to perform such actions.


With both of the above options (Full DB and DB-Filesystem), it is recommended to create a dedicated table space and use AL32UTF8 encoding.

Reclaiming BLOB space

For efficiency, Artifactory uses a checksum to ensure that only one copy of any binary data is stored, however, you may want to reclaim deleted BLOB space from time to time by shrinking the BLOB table space as follows.

{schema}.binary_blobs modify lob (data) (shrink space cascade);