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

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more