Re: ORA-00054 (alter table add partition)
- From: DBA Deepak <oracle.tutorials@xxxxxxxxx>
- To: Alex Fatkulin <afatkulin@xxxxxxxxx>
- Date: Thu, 15 Oct 2009 23:59:18 +0530
The application uses "alter table ... add partition..." to add the
partitions
On Thu, Oct 15, 2009 at 11:16 PM, Alex Fatkulin <afatkulin@xxxxxxxxx> 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@xxxxxxxxx>
> 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
Other related posts:
