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

If you don't supply a partition, or subpartition name, Oracle uses a sequence to generate a name - so you end up with names which, if I recall correctly, are like:

    SYS_P12345 or SYS_SUBP12345

--
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.0211032332.32d10ea7_at_posting.google.com>...


>Hi,

>thanks a lot, this was exactly what I needed.

>In meantime, I have read your article "Partitioning in 2 dimensions".

>I have found something interesting there also.

>Just a question: if there is no subpartiton name given during

creation


>of the table, does Oracle create kind of the name for it?

>Thanks

>Alex

>

>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message

news:<aq3v8p$2dp$3$8302bc10_at_news.demon.co.uk>...


>> 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.

>>

>>