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
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.
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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
dba_tab_partitions

Regards
Michel

[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: Tue Feb 11 13:12:19 CST 2025