ORA-27414: Invalid BY value type

Cause : The ytpe o fBY vlaue wsa nota llowde fort he ferquenyc speicfied

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

Ommi tBY vlaues fo thi stypeo r aletr th efreqeuncy

update : 28-06-2017
ORA-27414

ORA-27414 - Invalid BY value type
ORA-27414 - Invalid BY value type

  • ora-12659 : Error received from other process
  • ora-29872 : parameters clause cannot be combined with the specified options
  • ora-31407 : end_date must be greater than the begin_date
  • ora-16080 : invalid LogMiner session string for APPLY
  • ora-22981 : must specify a table/view having system generated OID
  • ora-24013 : invalid value string, RETRY_DELAY should be non-negative
  • ora-12666 : Dedicated server: outbound transport protocol different from inbound
  • ora-32550 : Replacement occured despite hint to the contrary
  • ora-30438 : unable to access named pipe 'string'
  • ora-39107 : Master process string violated startup protocol. Master error:
  • ora-31427 : publication string already subscribed
  • ora-32302 : object materialized views must be object ID based
  • ora-29952 : cannot issue DDL on a domain index partition marked as LOADING
  • ora-06781 : TLI Driver: error reading negotation string
  • ora-13291 : conversion error between the specified unit and standard unit
  • ora-01503 : CREATE CONTROLFILE failed
  • ora-38468 : column "string" is not identified as a column storing expressions.
  • ora-13185 : failed to generate initial HHCODE
  • ora-16160 : Cannot change protected standby database configuration
  • ora-19114 : error during parsing the XQuery expression: string
  • ora-19854 : error obtaining connect string from target
  • ora-01551 : extended rollback segment, pinned blocks released
  • ora-27370 : job slave failed to launch a job of type EXECUTABLE
  • ora-00219 : required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks)
  • ora-01149 : cannot shutdown - file string has online backup set
  • ora-19268 : XQ0048 - namespace string does not match target namespace string
  • ora-32123 : Attribute number is out of range
  • ora-00055 : maximum number of DML locks exceeded
  • ora-02785 : Invalid shared memory buffer size
  • ora-25506 : resource manager has not been continuously on in some instances
  • 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.