ALL SqlNav’s versions, 4,5,5.5 Beta have the same possibly bug. Extract ddl from subpartitioned table does not include information about table subpartition template (if exists of course), subpartitions list is incorrect. There is no code about whitch values should be in each subpartition. I’m using Toad too, there are no problems with ddl’s, it means I didn’t catch them since now.
In attachment are ddls for example.
My second suggestion is to add posibility of truncate/drop subpartitions from db navigator.
example.zip (901 Bytes)