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 : 25-04-2017

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

  • ora-13154 : invalid precision specified
  • ora-31516 : CDC change set string already exists
  • ora-19238 : XP0018 - focus not defined
  • ora-09760 : osnpui: cannot send break message
  • ora-16014 : log string sequence# string not archived, no available destinations
  • ora-00568 : Maximum number of interrupt handlers exceeded
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-13362 : disjoint sub-element in a compound polygon
  • ora-24801 : illegal parameter value in OCI lob function
  • ora-06979 : X.25 Driver: server cannot start oracle
  • ora-19662 : archived log thread string sequence string could not be verified
  • ora-08319 : sllfsk: Error reading file
  • ora-09967 : unable to create or open lock file
  • ora-16112 : log mining and apply stopping
  • ora-23414 : materialized view log for "string"."string" does not record rowid values
  • ora-22929 : invalid or missing directory name
  • ora-01031 : insufficient privileges
  • ora-23292 : The constraint does not exist
  • ora-13424 : the GeoRaster object is not spatially referenced
  • ora-30198 : reserved for future use
  • ora-01529 : error closing file 'string'
  • ora-16108 : database is no longer a standby database
  • ora-13863 : Statistics aggregation for service(module/action) string is not enabled
  • ora-06554 : package DBMS_STANDARD must be created before using PL/SQL
  • ora-19285 : FODC0002 - error retrieving resource
  • ora-00740 : datafile size of (string) blocks exceeds maximum file size
  • ora-32734 : Error occurred when sending Oradebug command to remote DIAGs
  • ora-16519 : the resource handle is invalid
  • ora-25252 : listen failed, the address string is a non-persistent queue
  • ora-28111 : insufficient privilege to evaluate policy predicate
  • 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.