Re: ORA-00054 (alter table add partition)

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Thu, 15 Oct 2009 13:46:38 -0400
Message-ID: <49d668000910151046o591a503et17230ce54581de10_at_mail.gmail.com>



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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 15 2009 - 12:46:38 CDT

Original text of this message