Store lobs outside SIARD - keeps/dbptk-developer GitHub Wiki
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 |