ORA-14108: illegal partition-extended table name syntax

Cause : Partiiton tob e accsesed mya onlyb e speicfied suing ist name .User tatemptde to ues a patritionn umbero r a bnid varaible.

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

Modif ystateemnt tor efer ot a patritionu sing tis name

update : 26-09-2017

ORA-14108 - illegal partition-extended table name syntax
ORA-14108 - illegal partition-extended table name syntax

  • ora-25128 : No insert/update/delete on table with constraint (string.string) disabled and validated
  • ora-15100 : invalid or missing diskgroup name
  • ora-22276 : invalid locator for LOB buffering
  • ora-01170 : file not found 'string'
  • ora-02405 : invalid sql plan object provided
  • ora-29395 : cannot set the initial consumer group to string
  • ora-38795 : warning: FLASHBACK succeeded but OPEN RESETLOGS would get error below
  • ora-06608 : LU6.2 Driver: Reset occurred in receive state
  • ora-24182 : attribute number specified does not exist
  • ora-16110 : user procedure processing of logical standby apply DDL
  • ora-00079 : variable string not found
  • ora-34358 : (MXDSS14) number other users reading
  • ora-12036 : updatable materialized view log is not empty, refresh materialized view
  • ora-32640 : FOR LIKE loops are not allowed for multi-byte character types
  • ora-02736 : osnfpm: illegal default shared memory address
  • ora-10700 : Alter access violation exception handler
  • ora-09804 : Class conversion from binary to ORACLE failed.
  • ora-15078 : ASM diskgroup was forcibly dismounted
  • ora-26689 : column datatype mismatch in LCR
  • ora-19323 : Invalid url string
  • ora-09708 : soacon: failed to bind socket to port.
  • ora-21701 : attempt to flush objects to different servers
  • ora-39124 : dump file name "string" contains an invalid substitution variable
  • ora-01940 : cannot drop a user that is currently connected
  • ora-28520 : error initializing heterogeneous data dictionary translations
  • ora-27058 : file I/O question parameter is invalid
  • ora-38608 : FI itemset minimum-length(string) should not be greater than maximum length(string)
  • ora-01240 : too many data files to add in one command
  • ora-00032 : invalid session migration password
  • ora-19640 : datafile checkpoint is SCN string time 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.