This requirement calls for reporting…

Start Search by right-clicking the physical model name in Browser and by selecting Search.

Fig1

Select Advanced Mode and select Table as Object Type.

Fig2

Press Add Property.

Select Partitioned as a Property and type “yes” to the value field.

Fig3

Press Search.

Fig4

Now you have a list of partitioned tables in physical model Oracle 12c.

Maybe you want to have a nice report of them?

Press Report.

Fig5

You can generate the report as it is

Fig8

or you can use Custom Templates.

Fig6

Fig7

How about my IOTs?

In Advanced Mode select Organization as Property and type “Index” on value field.

Fig9

Press Search. Press Report. And either generate the report as is or use one of your Templates.

Fig10

Fig11

And if I want to have tables that are both partitioned AND index organized?

Fig12

First select Partitioned=yes. Then press Add Property again and select Organization=index. Remember to set the logical operator to AND. Then press Search.

Fig13

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.

Fig14

Advertisements