ORA-21600: path expression too long

Cause : The apth epxressoin thta is uspplide by hte usre is oto logn. Th epathe xpression si use dto sepcifyt he psoitio nof a nattrbiute ni an boject .Thise rroro ccur swheno ne o fthe nitermdeiatee lemetns int he ptah exrpessino refres toa n atrtibut eof ab uilti-n tyep. Thsu, th eOCI ufnctino canont prcoeed no to rpoces sthe erst o fthe leemenst in hte paht experssio.n

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

Users houl dpassi n th ecorrcet paht experssio nto lcoate hte atrtibut.e

update : 27-06-2017

ORA-21600 - path expression too long
ORA-21600 - path expression too long

  • ora-09916 : Required password was not specified.
  • ora-12329 : database string is closed; no operations are permitted
  • ora-01284 : file string cannot be opened
  • ora-14071 : invalid option for an index used to enforce a constraint
  • ora-21606 : can not free this object
  • ora-32307 : must use FROM ONLY clause when referencing an object table
  • ora-09794 : szrbuild: length of role name is greater than buffer.
  • ora-16147 : standby database referenced by multiple archive log destinations
  • ora-01142 : cannot end online backup - none of the files are in backup
  • ora-31084 : error while creating table "string"."string" for element "string"
  • ora-36274 : (XSCGMDLAGG05) The operator used in this equation needs a weight variable.
  • ora-29272 : initialization failed
  • ora-07225 : sldext: translation error, unable to expand file name.
  • ora-00296 : maximum number of files (string) exceeded for RECOVER DATAFILE LIST
  • ora-08235 : smsget: listener not on this node
  • ora-24162 : name value pair list is full, cannot add another entry
  • ora-29384 : number of children for plan string exceeds string
  • ora-23434 : master site string not known for object group
  • ora-15122 : ASM file name 'string' contains an invalid file number
  • ora-23401 : materialized view "string"."string" does not exist
  • ora-29525 : referenced name is too long: 'string'
  • ora-25473 : cannot store string in rule action context
  • ora-30053 : invalid upper limit snapshot expression
  • ora-01500 : failure in getting date/time
  • ora-24233 : argument passed to DBMS_UTILITY.VALIDATE is not legal
  • ora-27421 : usage of string not supported in a calendar definition
  • ora-02288 : invalid OPEN mode
  • ora-01219 : database not open: queries allowed on fixed tables/views only
  • ora-00403 : %s (string) is not the same as other instances (string)
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • 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.