Home » SQL & PL/SQL » SQL & PL/SQL » how can I get the right partition name
how can I get the right partition name [message #293661] Mon, 14 January 2008 08:12 Go to next message
Messages: 16
Registered: November 2006
Junior Member

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.
Re: how can I get the right partition name [message #293663 is a reply to message #293661] Mon, 14 January 2008 08:26 Go to previous message
Michel Cadot
Messages: 63910
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator


[Updated on: Mon, 14 January 2008 08:26]

Report message to a moderator

Previous Topic: Distinct Count Help
Next Topic: sql query failing with order by
Goto Forum:

Current Time: Mon Oct 24 04:32:31 CDT 2016

Total time taken to generate the page: 0.15701 seconds