sql - Table partitions in oracle with alter command -


i have create partitions dynamically oracle table in java program , user input. if user enters 3 have make 3 partitions. there table around 100 columns. problem when executing below query in sql developer giving error shown below.

is there alternative add 3 or more partitions @ time alter command or must alter table 3 times 3 partitions?

i using 'oracle 9i', suggest thing

thanks in advance

sql query

alter table table_01  add  partition p2 values less than(20), partition p3 values less than(30), partition p4 values less than(40); 

error

error report - sql error: ora-14043: 1 partition may added 14043. 00000 -  "only 1 partition may added" *cause:    alter table add partition contained descriptions of more  1        partition added *action:   ensure statement contains 1 partition        definition , not contain commas 

" using 'oracle 9i', suggest thing"

i'm afraid suggestion upgrade more recent version of oracle. 9i has been out of support decade.

oracle 12c supports the syntax want implement. previous versions support adding single partition @ time; have checked 11gr2 , hurls ora-14043: 1 partition may added.

if can't upgrade you'll have write application add partitions in multiple statements.


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -