Partitioning a table In Asm works just find. This has to be a newbie, some storage hardware recommends not putting a partition on a device when using it with ASM, but there is no problem with Oracle partitioning. Sent from my iPad On Mar 18, 2013, at 6:52 AM, Thomas Kellerer <thomas.kellerer@xxxxxxxxxx> wrote: > Hallo all, > > we recently suggested to one of our clients to use table partitioning in > order to make deleting old stuff from a large table faster. > > The partition would have been a range partition over a DATE column. We only > keep the last 6 months of data in that table and dropping a partition is much > faster than deleting 10% of a table with ~50 million rows. > > Now the (outsourced) DBA of the customer claimed that partitioning is not > possible when using ASM (which the production system is using). > The production system is a two node RAC running 11.2.0.3 on Oracle Linux > (don't know the exact OS version though) > > I'm pretty sure that this is a wrong statement, but just wanted to confirm > this. > > So: is there any (technical) limitation to table partitioning when using ASM > on a RAC system? (licensing is not issue) > > Thanks in advance > Thomas > > -- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l