Re: ASM and partitioning
- From: rajugaru.vij@xxxxxxxxx
- To: thomas.kellerer@xxxxxxxxxx,"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Mar 2013 12:59:38 +0000
Hi,
Nothing too do with ASM, if properly licensed should work fine.
Sent on my BlackBerry®
-----Original Message-----
From: Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Date: Mon, 18 Mar 2013 13:52:39
To: oracle-l@xxxxxxxxxxxxx<oracle-l@xxxxxxxxxxxxx>
Reply-To: thomas.kellerer@xxxxxxxxxx
Subject: ASM and partitioning
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
Other related posts:
