ORA-14043: only one partition may be added

Cause : ALTER TABLE ADD PARTITION contained descriptions of more than one partition to be added

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Ensure that the statement contains exactly one partition definition and that it does not contain any commas

update : 17-08-2017

ORA-14043 - only one partition may be added
ORA-14043 - only one partition may be added

  • ora-06141 : NETTCP: no privilege for user
  • ora-01608 : cannot bring rollback segment 'string' online, its status is (string)
  • ora-39783 : Invalid direct path transaction active
  • ora-16044 : destination string attribute cannot be specified at session level
  • ora-28153 : Invalid client initial role specified: 'string'
  • ora-12923 : tablespace string is in force logging mode
  • ora-16569 : Data Guard configuration is not enabled
  • ora-06134 : NETTCP: file access privilege violation
  • ora-14252 : invalid ALTER TABLE MODIFY PARTITION option for a Hash partition
  • ora-26099 : direct path context is already prepared
  • ora-01480 : trailing null missing from STR bind value
  • ora-32335 : dimension must have at least one level
  • ora-06802 : TLI Driver: could not open the /etc/netware/yellowpages file
  • ora-00328 : archived log ends at change string, need later change string
  • ora-14009 : partition bound may not be specified for a LOCAL index partition
  • ora-14254 : cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
  • ora-02842 : Client unable to fork a server
  • ora-00343 : too many errors, log member closed
  • ora-06973 : X.25 Driver: invalid buffer size
  • ora-14082 : new partition name must differ from that of any other partition of the object
  • ora-32116 : Buffer size is less than amount specified
  • ora-13344 : an arcpolygon geometry has fewer than five coordinates
  • ora-30373 : object data types are not supported in this context
  • ora-06521 : PL/SQL: Error mapping function
  • ora-06975 : X.25 Driver: connect to host failed
  • ora-24409 : client cannot understand the object
  • ora-04934 : unable to obtain the current sequence number
  • ora-25126 : Invalid name specified for BUFFER_POOL
  • ora-00335 : online log string: No log with this number, log does not exist
  • ora-33064 : (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.