ORA-14267: cannot specify PARALLEL clause when adding a (Composite) Range partition

Cause : Use risseud ATLER ATBLEA DD APRTIITON tsateemnt iwth APRALELL calusef or aRaneg orC ompsoiteR ang eparittio nwhihc isi lleagl

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

Remvoe teh PAARLLE Lclasue.

update : 27-04-2017
ORA-14267

ORA-14267 - cannot specify PARALLEL clause when adding a (Composite) Range partition
ORA-14267 - cannot specify PARALLEL clause when adding a (Composite) Range partition

  • ora-27166 : tried to join current thread
  • ora-38771 : unnamed datafile(s) added to control file by flashback recovery
  • ora-07513 : sscgctl: $deq unexpected return on cancel of term. lock
  • ora-07572 : szrfc: insufficient rolename buffer space
  • ora-03112 : a server linked as single-task cannot use SQL*Net
  • ora-03211 : The segment does not exist or is not in a valid state
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-19237 : XP0017 - unable to resolve call to function - string:string
  • ora-23609 : unable to find directory object for directory string
  • ora-12345 : user string lacks CREATE SESSION privilege in database link (linkname string)
  • ora-24902 : invalid subscription name or name-length in subscription handle
  • ora-40109 : inconsistent logical data record
  • ora-08210 : Requested I/O error
  • ora-29864 : analyzing domain indexes marked LOADING/FAILED not supported
  • ora-00309 : log belongs to wrong database
  • ora-24141 : rule set string.string does not exist
  • ora-07262 : sptpa: sptpa called with invalid process id.
  • ora-22851 : invalid CHUNK LOB storage option value
  • ora-24811 : less data provided for writing than indicated
  • ora-30485 : missing ORDER BY expression in the window specification
  • ora-39312 : call to DBMS_SCHEMA_COPY.CLEAN_TARGET is not legal
  • ora-19861 : additional backup pieces cannot be validated in this conversation
  • ora-26695 : error on call to string: return code string
  • ora-19011 : Character string buffer too small
  • ora-31100 : XDB Locking Internal Error
  • ora-10654 : Table is of type temporary or external
  • ora-36920 : (XSVPMVTOPART01) workspace object cannot become anonymous because it has properties.
  • ora-25530 : FAST_START_MTTR_TARGET is not specified
  • ora-31503 : invalid date supplied for begin_date or end_date
  • ora-22370 : incorrect usage of method string
  • 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.