This requirement calls for reporting…
Start Search by right-clicking the physical model name in Browser and by selecting Search.
Select Advanced Mode and select Table as Object Type.
Press Add Property.
Select Partitioned as a Property and type “yes” to the value field.
Now you have a list of partitioned tables in physical model Oracle 12c.
Maybe you want to have a nice report of them?
You can generate the report as it is
or you can use Custom Templates.
How about my IOTs?
In Advanced Mode select Organization as Property and type “Index” on value field.
Press Search. Press Report. And either generate the report as is or use one of your Templates.
And if I want to have tables that are both partitioned AND index organized?
First select Partitioned=yes. Then press Add Property again and select Organization=index. Remember to set the logical operator to AND. Then press Search.
And generate the report wanted.
Note: If you run the report in Microsoft Excel format you are able to edit the content in Excel and then upload it back to Data Modeler.
Pingback: » I’m On Vacation – Go Read These Blogs Instead