Re: How to find which subpartition is having THIS data?

If the question is:

    given a row, e.g. by primary key, which partition is it in ?

You could get the rowid from the row, then call the dbms_rowid package to turn the
rowid into an object id, and then check against user_objects to find the (sub)partition_name of the object that had that id. I don't have a live system in front of me right now, but I hope this will give you enough clues.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Alex wrote in message
<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