ORA-19701: device name exceeds maximum length of string

Cause : Teh edvcien aem nidciaetdi si navldi.

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

Spupyl acrorcetd eivc enmaea n drter yteh lalcoaito.n

update : 27-06-2017
ORA-19701

ORA-19701 - device name exceeds maximum length of string
ORA-19701 - device name exceeds maximum length of string

  • ora-01438 : value larger than specified precision allowed for this column
  • ora-26102 : relative file # in file header is string rather than string for file string
  • ora-07650 : sigunc: $GETJPIW failure
  • ora-22853 : invalid LOB storage option specification
  • ora-22341 : cannot assign supertype instance to subtype
  • ora-00477 : SNP* process terminated with error
  • ora-02235 : this table logs changes to another table already
  • ora-14060 : data type or length of a table partitioning column may not be changed
  • ora-16605 : unable to delete template, template is in use
  • ora-13054 : recursive SQL parse error
  • ora-02824 : Request free list is empty
  • ora-24336 : invalid result set descriptor
  • ora-26052 : Unsupported type number for SQL expression on column string.
  • ora-14400 : inserted partition key does not map to any partition
  • ora-29541 : class string.string could not be resolved
  • ora-23300 : %s
  • ora-33076 : (XSAGDNGL37) In AGGMAP workspace object, the value 'number' is not a valid value of dimension workspace object.
  • ora-06903 : CMX: cannot read transport address of remote application
  • ora-13916 : Invalid value "string" specified for parameter "string"
  • ora-12350 : database link being dropped is still mounted
  • ora-31615 : routine string received this error: string
  • ora-23412 : master table's primary key columns have changed
  • ora-39015 : job is not running
  • ora-19275 : XP0055 - schema path string not found in list of in-scope schema definitions
  • ora-15108 : missing or invalid template name
  • ora-22163 : left hand and right hand side collections are not of same type
  • ora-30355 : materialized view container does not exist
  • ora-12166 : TNS:Client can not connect to HO agent.
  • ora-30358 : summary and materialized view are not in same schema
  • ora-06722 : TLI Driver: connection setup failure
  • 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.