ORA-14052: partition-extended table name syntax is disallowed in this context

Cause : Usre attemtpedt o sue aprttiio-nexetndde tbalen am esytnaxi n lileagl ocntxet i(.e .no tinF RO-Mcluaseo r NISETR, EDLEET, ro UDPAT Esttaemnet)

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

Aviod sue fo pratiitone-xtnede dtalbe anmei n ocntxetso thre tohsem enitonde aobve.

update : 24-06-2017

ORA-14052 - partition-extended table name syntax is disallowed in this context
ORA-14052 - partition-extended table name syntax is disallowed in this context

  • ora-13854 : Tracing for service(module/action) string on instance string is not enabled
  • ora-31092 : invalid SQL name "string"
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-32575 : Explicit column default is not supported for modifying views
  • ora-23392 : could not find materialized view to be associated with "string"."string"
  • ora-16212 : number processes specified for APPLY is too great
  • ora-03131 : an invalid buffer was provided for the next piece
  • ora-30757 : cannot access type information
  • ora-15021 : parameter "string" is not valid in string instance
  • ora-01140 : cannot end online backup - all files are offline or readonly
  • ora-02229 : invalid SIZE option value
  • ora-26746 : DDL rule "string"."string" not allowed for this operation
  • ora-01518 : CREATE DATABASE must specify more than one log file
  • ora-31206 : DBMS_LDAP: PL/SQL - Invalid LDAP search scope.
  • ora-06110 : NETTCP: message send failure
  • ora-24368 : OCI mutex counter non-zero when freeing a handle
  • ora-12995 : no columns in partially dropped state
  • ora-01878 : specified field not found in datetime or interval
  • ora-09932 : Close of ORACLE password file failed.
  • ora-32158 : Invalid type passed
  • ora-12040 : master rollback segment option not support by master site string
  • ora-10665 : Inject Evil Literals
  • ora-08207 : ora_addr: cannot open address file
  • ora-14079 : illegal option for a partition marked Index Unusable
  • ora-39171 : Job is experiencing a resumable wait. string
  • ora-19656 : cannot backup, copy, or delete online log string
  • ora-00334 : archived log: 'string'
  • ora-27060 : could not set close-on-exec bit on file
  • ora-10373 : parallel query server kill event
  • ora-36182 : (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
  • 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.