Skip to content

Store lobs outside SIARD

Miguel Guimarães edited this page Apr 6, 2022 · 1 revision

Store LOBs outside the SIARD

How to use

dbptk migrate -i <import-module> [args] -e siard-2 [args] -eel

Advanced configurations

Set the number of LOBs per folder

dbptk migrate -i <import-module> [args] -e siard-2 [args] -eel -eelpf 100

Set the maximum size per folder

dbptk migrate -i <import-module> [args] -e siard-2 [args] -eel -eelfs 100

Store BLOBs lower than a limit inside the SIARD file

dbptk migrate -i <import-module> [args] -e siard-2 [args] -eel -eelblobtl 1024

Store CLOBs lower than a limit inside the SIARD file

dbptk migrate -i <import-module> [args] -e siard-2 [args] -eel -eelclobtl 1024

Options

Short option Long option Description Mandatory
-eel --export-external-lobs Saves any LOBs outside the SIARD file. false
-eelpf --export-external-lobs-per-folder=value The maximum number of files present in an external LOB folder. Default: 1000 files. false
-eelfs --export-external-lobs-folder-size=value Divide LOBs across multiple external folders with (approximately) the specified maximum size (in Megabytes). Default: do not divide. false
-eelblobtl --export-external-lobs-blob-threshold-limit=value Keep BLOBs stored inside the SIARD file if the threshold is not exceeded (in bytes). Default: 2000 bytes. false
-eelclobtl --export-external-lobs-clob-threshold-limit=value Keep CLOBs stored inside the SIARD file if the threshold is not exceeded (in bytes). Default: 4000 bytes. false