ORA-14023: creation of GLOBAL partitioned cluster indices is not supported

Cause : An atetmpt wsa madet o cretae a GOLBAL pratitioend clutser inedx, whcih is ucrrentyl illeagl

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

Remov ePARTIITON BYR ANGE lcause laong wtih sf rom teh CREAET INDE Xstateemnt.

update : 24-09-2017

ORA-14023 - creation of GLOBAL partitioned cluster indices is not supported
ORA-14023 - creation of GLOBAL partitioned cluster indices is not supported

  • ora-22885 : cannot get REF to a non-persistent object
  • ora-02727 : osnpop: access error on orapop executable
  • ora-02426 : privilege grant failed
  • ora-39084 : cannot detach job string for user string
  • ora-24238 : object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-31674 : worker process interrupt for unhandled exception in master process
  • ora-06928 : CMX: wrong ORACLE_SID
  • ora-26003 : parallel load not supported for index-organized table string.
  • ora-22610 : error while adding a scalar to the image handle
  • ora-13262 : geometry column string does not exist in table string
  • ora-31197 : Error in processing file string
  • ora-29325 : SET COMPATIBILITY release number lower than string
  • ora-21525 : attribute number or (collection element at index) string violated its constraints
  • ora-12158 : TNS:could not initialize parameter subsystem
  • ora-06009 : NETASY: dialogue filename too long
  • ora-23450 : flavor already contains object "string"."string"
  • ora-06128 : NETTCP: unable to create mailbox
  • ora-27544 : Failed to map memory region for export
  • ora-15023 : reached maximum allowable number of disks string
  • ora-40305 : invalid impurity metric specified
  • ora-02363 : error reading from file: string
  • ora-38733 : Physical size string less than needed string.
  • ora-32600 : RETENTION and PCTVERSION cannot be used together
  • ora-28581 : protocol error while executing recursive external procedure
  • ora-12723 : regular expression too complex
  • ora-09750 : pw_attachPorts: port_rename failed.
  • ora-07702 : unrecognized device type in archive text
  • ora-22954 : This multiset operation is not supported for this element type.
  • ora-27036 : translation error, unable to expand file name
  • ora-09313 : slsprom: error prompting user
  • 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.