Question: How do I quickly see what partition
an row belongs in? I want to find the partition for
any given row such that I can select the partition name for
a rows and see what partition is associated with any given
Answer: The Oracle partition is supposed to
be transparent and the data attributes of the row (salient
columns) determine which partition as row is assigned to.
column partition_name format a20
column subpartition_name format
acquire the ROWID for a table you can run queries to get the
partition for a table, or you could use complex scripts such
as this to reveal riws within oartitions.
'''' from regexp_substr (
'select high_value from all_tab_partitions
|| ''' and table_owner = '''
|| ''' and partition_name = '''
table_name = 'SALES' and table_owner = 'SH'
many other ways to find the partition where a rows resides
and a Google search will reveal these SQL statements.