Just to throw it in here. DBMS_ROWID, as JPL said, can be used for
this purpose. Compare the object_number that you get from DBMS_ROWID
to the "data_object_id" in user_objects. Data_object_id and object_id
cab be different. This happens when you, say, exchange a partition
(with hash sub-partitions) with a hash-partitioned table. In this
case, no actual data movement occurrs. ORACLE simply swaps the
data_object_id of the 2 objects while the object_ids remain same.
Ashche_at_yahoo.com (Alex) wrote in message news:<44f08c9d.0211021249.1a962840_at_posting.google.com>...
> Dear *,
> I have a begginers question: having a table with composite
> partitioning, how to find out where data is? Which hash subpartition
> is containing the ROW? I would like to have a method giving me all
> ROWIDs from the subpartition for example or something like this.
> I count on you :-)
> Thanks
> Alex
Received on Tue Nov 05 2002 - 15:35:22 CST
