Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!canoe.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: netcomrade@netscape.net (NetComrade) Newsgroups: comp.databases.oracle.server Subject: Mapping the get_hashed_value to the actual partition Date: 10 Oct 2002 19:39:43 -0700 Organization: http://groups.google.com/ Lines: 20 Message-ID: NNTP-Posting-Host: 66.114.78.65 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1034303983 16082 127.0.0.1 (11 Oct 2002 02:39:43 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 11 Oct 2002 02:39:43 GMT Xref: newsfeed1.easynews.com comp.databases.oracle.server:163812 X-Received-Date: Thu, 10 Oct 2002 19:39:39 MST (news.easynews.com) I have a table with hashed partitions, and was trying to figure out how to figure out where my data is (for restoration from an exp). If I do something like select dbms_utility.get_hash_value(:my_value,0,:num_partitions) from dual; I get a number in return, however there is no such thing as 'partition_id', or I couldn't find it. Oracle assigns fairly random #'s to partitions (although consecutive), but I recall renaming them. The only way I can see this work is thru trial and error. (e.g. restore partition one by one and see what they have in them, and see what get_hash_value returns). Does anybody have a better method? Thanx. --- oracle 8.1.7, solaris 7