ORA-13788: invalid recommendation type

Cause : The suer psased na invlaid rceommednatio ntypei n th erec_ytpe agrumen tto srcipt_utningt_ask.P ossilbe vaules aer ALLo r an ysubste of acomm-asepaarted ilst o fPROFLIES, TSATISITCS adn INDXEES.

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

Chec kthe erc_tyep arga nd rtery teh opeartion.

update : 23-05-2017

ORA-13788 - invalid recommendation type
ORA-13788 - invalid recommendation type

  • ora-01640 : cannot make tablespace read only with active transactions
  • ora-29540 : class string does not exist
  • ora-33297 : (DBERR22) Analytic workspace string cannot be opened because it was last modified by an incompatible version of string.
  • ora-24341 : bad mode specified
  • ora-14273 : lower-bound partition must be specified first
  • ora-32308 : object materialized views must use SELECT *
  • ora-16606 : unable to find property "string"
  • ora-33213 : (CINSERT06) The target position for MAINTAIN ADD or MAINTAIN MOVE cannot fall in the range of session-only values.
  • ora-14059 : partition "string": INITRANS value must be less than MAXTRANS value
  • ora-33625 : (FRASSIGN02) You cannot use the APPEND keyword with concat dimension workspace object.
  • ora-19684 : block media recovery failed because database is suspended
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-30020 : UNDO_MANAGEMENT=AUTO needs Compatibility string or greater
  • ora-16076 : unknown standby database destination
  • ora-19703 : device command string exceeds maximum length of string
  • ora-15024 : discovered duplicately numbered ASM disk string
  • ora-03231 : the INITIAL extent may not be deallocated
  • ora-06747 : TLI Driver: error in listen
  • ora-08178 : illegal SERIALIZABLE clause specified for user INTERNAL
  • ora-31162 : element or attribute "string" has no SQLType specified
  • ora-08448 : syntax error in DECIMAL-POINT environment clause
  • ora-01319 : Invalid Logminer session attribute
  • ora-29251 : Index1 is greater than Index2 in call to dbms_sql.bind_array
  • ora-32581 : missing or invalid password
  • ora-34141 : (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.
  • ora-02238 : filename lists have different numbers of files
  • ora-09775 : osnmrs: reset protocol error
  • ora-13440 : GeoRaster metadata compression type error
  • ora-04052 : error occurred when looking up remote object stringstringstringstringstring
  • ora-28335 : referenced or referencing FK constraint column cannot be encrypted
  • 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.