(using 864 build)
I have run into two issues and I’m not sure if they are related.
We have several Oracle instances around here and no two of them have the same permissions for the IDs we connect with. So I spend a lot of time in the Preferences screen changing the “enable using DBA dictionary views” setting back and forth. (Side note - it would be nice if this was a per session setting instead of a global setting.)
When connecting to Oracle version 184.108.40.206
When using the BETA 864 build, I get a DDL regardless of the dictionary views setting (but with it enabled an error message shows up in the logs - this makes sense) but neither attempt contains any reference to the subpartitions.
Changing the “List individual hash partitions” also changes nothing in the output.
Changing the “Storage Clause Options” to show ALL stops the DDL from extracting at all. Setting it to show only non-default values goes back to showing a DDL (still with no subpartition information)
EDIT: Ignore the bit about not being able to extract the subpartition DDL. Someon echanged the table without telling me and there no longer ARE subpartitions…