Toad World® Forums

Extract DDL of subpartitioned tables


#1

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.

Best Regards!

example.zip (901 Bytes)


#2

piortek,

Great catch!
Thanks for your other suggestion as well. I have created enhancement requests for both issues on your behalf.
Watch out this space for future developments.

Rgds,
Andrew