ORA-14030: non-existent partitioning column in CREATE TABLE statement

Cause : aPtrtioiingnc lomu npscefiei dniC ERTA EATLB Etstamene tsin too eno foculnm sfot eht baelb iegnc ertade.

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

nEusert ah tla loculnm snit ehp raititnoni goculnml si tra eoculnm sfot eht baelb iegnc ertade.

update : 23-08-2017
ORA-14030

ORA-14030 - non-existent partitioning column in CREATE TABLE statement
ORA-14030 - non-existent partitioning column in CREATE TABLE statement

  • ora-01615 : instance string (thread string) is mounted - cannot disable
  • ora-19024 : Cursor expression must be named
  • ora-15198 : operation string is not yet available
  • ora-22865 : more than one column specified
  • ora-27067 : size of I/O buffer is invalid
  • ora-19251 : XQ0031 - unsupported query version
  • ora-12901 : default temporary tablespace must be of TEMPORARY type
  • ora-13644 : The user "string" is invalid.
  • ora-39026 : master table is inconsistent on validation string
  • ora-27416 : BYDAY= clause in repeat interval or calendar contains an invalid weekday
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-06806 : TLI Driver: could not complete protocol initialization for SPX
  • ora-06557 : null values are not allowed for any parameters to pipe icd's
  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-35020 : (QFCHECK02) The analytic workspace and EIF file definitions of workspace object have mismatched dimensioning.
  • ora-37026 : (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.
  • ora-12583 : TNS:no reader
  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-13455 : GeoRaster metadata TRS error
  • ora-24191 : the property name string has existed
  • ora-02310 : exceeded maximum number of allowable columns in table
  • ora-13197 : element string.string.string is out of range
  • ora-21560 : argument string is null, invalid, or out of range
  • ora-12448 : policy string not applied to schema string
  • ora-21780 : Maximum number of object durations exceeded.
  • ora-32311 : materialized view definition query selects an unsupported user-defined type
  • ora-12680 : Native services disabled but required
  • ora-29377 : consumer group string is not part of top-plan string
  • ora-14630 : subpartition resides in offlined tablespace
  • ora-30192 : reserved for future use
  • 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.