Ralf Wisser

One quick follow-up: I've added a FAQ entry that describes exactly the "more than one subject" approach we discussed — using the "Add Subject" button in the Extraction Model Editor to add each child table as its own subject (scoped to the parent subset), so you can export several child tables in a single operation, optionally without the parent rows. See "Can a model have more than one subject (additional subjects)?" here: https://wisser.github.io/Jailer/faq.html Best regards, Ralf

Hi Scott, The key idea is that one extraction model + one export produces a single, consistent dataset — Jailer collects the whole closure (subjects + everything reachable over the enabled associations) in one run, so you never merge separate extracts. What ends up in the file is controlled by which tables are subjects (with their Where conditions) and which associations are enabled vs. restricted. The Data Export guide covers this: https://wisser.github.io/Jailer/exporting-data.htm 1) All child...

What the problem here?

How many rows are there in the JAILER_ENTITY table (and the other JAILER_* tables)? If subsetting processes are aborted, data may remain in the tables and accumulate over time. You can safely delete this data. If that's not the case, I don't know why the gathering process is taking so long either. I'm not an Oracle expert.

Depending on how you installed the tool, this file may not exist. In that case, create the two folders and the (empty) file yourself. Either in the installation directory or in the “.jailer” folder in your user directory.

there is a scrpt: script/oracle/gatherStatistics.sql that is used to trigger stats are being gathered. Remove the statements in that file to prevent gathering stats. HTH, Ralf

The errors occur when the icons in “net/sf/jailer/ui/resource” are not on the classpath. Are you trying to build the tool yourself? If so, please make sure they are.

The extraction model is created manually. After all, this is the means of determining exactly which data you want to extract. The exports are then carried out using this extraction model. Best regards, Ralf