Re: Partitioned tables / split clause

"chris b" <chris.brown_at_providenthims.co.uk> wrote in message news:1136996498.212939.291720_at_g49g2000cwa.googlegroups.com...
> I've been trying to create a partition at the end of a table & got
> ora-14074/ metalink advised I should use the split syntax but I can't
> seem to get it to work
>
> Please find enclosed example
>
> SQL> ALTER TABLE DS_ORGANISATION SPLIT PARTITION START_DATE_2006 VALUES
> LESS THAN TO_DATE('01-01-2007', 'DD-MM-YYYY') TABLESPACE DSTPDATSML2;
>
> I am trying to add a partition ...does anyone have the right
> syntax/advisce?
>
>
> Thanks in advance for any help you can give
> cheers
> Chris B
>
> PS Oracle is 9.2.0.5 EE
>

This looks about right.
You split AT a value, and INTO two other partitions.

ALTER TABLE DS_ORGANISATION
SPLIT PARTITION START_DATE_2006
at TO_DATE('01-01-2007', 'DD-MM-YYYY')
into (

    partition start_date_2006 tablespace DSTPDATSML2,     partition start_date_2007 tablespace DSTPDATSML3 )
;

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 10th Jan 2006