v$ table for partition option
I want to write a query to determine if partitioning is used in the database or not.
I don't want to look at v$option, because that only tells me if the option is installed or not. Just because the option is installed does not mean it is being used.
I know about dba_part_tables and dba_tab_partitions, but those tables are not available when querying a database in managed recovery mode (standby database).
I know about sys.obj$ where type# in (19,20), but sys.obj$ is not available when I am managed recovery mode.
In managed recovery mode, I can only query fixed v$ views.