Re: ORA-00054 (alter table add partition)

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Thu, 15 Oct 2009 23:59:18 +0530
Message-ID: <75aa80160910151129m6f83a36csa6989c0dec2a07bc_at_mail.gmail.com>

The application uses "alter table ... add partition..." to add the partitions

On Thu, Oct 15, 2009 at 11:16 PM, Alex Fatkulin <afatkulin_at_gmail.com> wrote:

> Hi,
>
> could you clarify how partitions are being added? Are they using alter
> table add partition or do they have, say, one partition with MAVALUE
> and they do alter table split partition ?
>
> On Thu, Oct 15, 2009 at 1:23 PM, DBA Deepak <oracle.tutorials_at_gmail.com>
> wrote:
>
> >
> > The partitions are created using the following algorithms
> >
> > for count=1..100
> > add partition <count> to table T1
> >
> > Need your help in understanding why the behaviour is like this and what
> > would be the fix for this issue?
> > --
> > Regards,
> >
> > Deepak
> > Oracle DBA
> >
>
> --
> Alex Fatkulin,
> http://afatkulin.blogspot.com
> http://www.linkedin.com/in/alexfatkulin
>

-- 
Regards,

Deepak
Oracle DBA

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

Received on Thu Oct 15 2009 - 13:29:18 CDT