how can I get the right partition name [message #293661] |
Mon, 14 January 2008 08:12  |
ndahafa
Messages: 16 Registered: November 2006
|
Junior Member |
|
|
hi,
I have a table range partitioned by date (monthly), an example of a partition name would be PREPAID_CALLS_DEC07. With local indexes.
I have a PL/SQL stored procedure which loads a previous day's data into this table every morning. Before I load data into the table I want to be able to first make the indexes unusable, and rebuild them after loading.
However, I do not want to rebuild indexes for the whole table, only for the partition into which I inserted data. How can I get that specific partition name?
I'm on Oracle 10g.
|
|
|
|