Re: ASM and partitioning

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 18 Mar 2013 08:17:26 -0600
Message-Id: <F848708F-312F-4F71-A07D-40B85E124C02_at_gmail.com>

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_at_mgm-tp.com> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 18 2013 - 15:17:26 CET