The PhysicalDesignContents relationship query returns the names of all Oracle tables, views, indexes, tablespaces and databases which are contained in the specified Oracle physical design. The query is sorted on the lastUpdate timestamp so you can find the objects which have changed most recently.
View type: DAQOraclePhysicalDesign
Modifications:
The query uses a SQL UNION clause to provide a more compact and readable table. In order to change the search criteria, you must change it for each subselect statement in the UNION. Change the search criteria of the Physical Design name using the = (equals), IN or LIKE elements in the SQL WHERE clause.
In order to provide unique names, the PhysicalDesign name has the format <>RelationalDesignName:PhysicalDesignName<variation:revision>
To locate a Physical Design name used in multiple Relational Designs, use the LIKE clause with % after the first two angle brackets and before the colon.