Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: split partition (range partition) error

Re: split partition (range partition) error

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sat, 30 Apr 2005 23:53:20 -0400
Message-ID: <f09dd628050430205318b469ef@mail.gmail.com>


Tim,

Yes. my issue is associated with bug #2861165. Anyway I did not have any data for the partition in question. So I dropped the partition and recreated smaller partitions instead of SPLIT.

Thanks again
Sami

On 4/30/05, Tim Gorman <tim_at_evdbt.com> wrote:
> Sami,

>=20

> Bug #2861165 seems to be a "hit" on your symptoms and it indicates that a
> workaround is to explicitly grant SELECT ANY TABLE to the user in questio=
n;
> apparently the problem is fixed in 10g.
>=20
> -Tim
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 30 2005 - 23:57:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US