ORA-14308: partition bound element must be one of: string, datetime or interval literal, number, or NULL

Cause : Parittio nboudn lits cotnainde ane lemnet o finvlaid ytpe i(.e.n ot anumebr, onn-epmty tsrin,g daettim eor niteravl ltiera,l orN ULL)

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

Ensrue taht all elmeent sof aprtiiton obundl ista re fo vaild tpye

update : 22-08-2017

ORA-14308 - partition bound element must be one of: string, datetime or interval literal, number, or NULL
ORA-14308 - partition bound element must be one of: string, datetime or interval literal, number, or NULL

  • ora-40205 : invalid setting name string
  • ora-07645 : sszfsl: $CHANGE_CLASS failure
  • ora-22984 : view query cannot contain references to a super view
  • ora-32507 : expecting string but found string
  • ora-32806 : value for string is too long, maximum length is string
  • ora-22054 : underflow error
  • ora-00038 : Cannot create session: server group belongs to another user
  • ora-07460 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-08431 : raw data missing zero as defined in picture
  • ora-13358 : circle type does not contain 3 points
  • ora-00083 : warning: possibly corrupt SGA mapped
  • ora-22850 : duplicate LOB storage option specificed
  • ora-16145 : archival for thread# string sequence# string in progress
  • ora-08267 : destroy_ora_addr: cannot close nameserver
  • ora-30963 : The indexed column is not of XMLType.
  • ora-00228 : length of alternate control file name exceeds maximum of string
  • ora-36643 : (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
  • ora-19805 : recid string of string was deleted to reclaim disk space
  • ora-30729 : maximum number of columns exceeded
  • ora-23536 : the object "string"."string" is not cached at the middle tier as expected.
  • ora-02472 : PL/SQL functions not allowed in hash expressions
  • ora-25508 : database is not mounted
  • ora-16186 : Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier
  • ora-02095 : specified initialization parameter cannot be modified
  • ora-01156 : recovery in progress may need access to files
  • ora-23415 : materialized view log for "string"."string" does not record the primary key
  • ora-16232 : adding Logical Standby skip entry for table string.string
  • ora-23500 : cannot switch master for a multi-tier materialized view repgroup "string"."string"
  • ora-09276 : All bequeath database links must be loopback database links
  • ora-01140 : cannot end online backup - all files are offline or readonly
  • 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.