This discussion is archived
2 Replies Latest reply: Oct 10, 2013 8:16 PM by user12075536123 RSS

identify partition name from input data

supersen Newbie
Currently Being Moderated


Hi gurus,

 

Pleae help for the below

 

based on the input data i have to delete the partition from the table.

 

suppose if a table PART  is partitioned based on the column id  number.  if my input data is 10 if it is present in the partition then i want to identifiy the partition_name.. 

 

Please help  how to identify the partition name based on input data?

 

Reply

 

S

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points