Partition name from table
How do find out the partition name where the data from the table is stored.
select partition_name, column_a from table;
(partition_name is not one of my columns in this table)
I'm not sure what you want.
Does this help?
WHERE table_name = 'TABLE';
WHERE owner = 'OWNER' AND
table_name = 'TABLE';
You can get the partition name from the subobject_name column of the all/user/dba_objects view. The object id for the partition is retrieved by the supplied procedure DBMS_MVIEW.PMARKER().
For example ...
ao.object_id = DBMS_MVIEW.PMARKER(mt.rowid)
This is exactly what I'm looking for - but for some reason, the object_id returned from the dbms_mview.pmarker(rowid) doesn't exist in the user_objects table.
I figured it out....
the DBMS_MVIEW.PMARKER(rowid) returns the data_object_id from the user_objects table, not the object_id.
Thanks for all your help.
Click Here to Expand Forum to Full Width