Database Administration (MOSC)

MOSC Banner

v$ table for partition option

edited Oct 27, 2019 5:05AM in Database Administration (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center