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 : 25-05-2017
ORA-19701

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

  • ora-22885 : cannot get REF to a non-persistent object
  • ora-31462 : internal error while accessing metadata
  • ora-30647 : error retrieving access parameters for external table string.string
  • ora-24750 : incorrect size of attribute
  • ora-30752 : column or table string is not substitutable
  • ora-19010 : Cannot insert XML fragments
  • ora-30930 : NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn
  • ora-37030 : (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.
  • ora-32340 : cannot tune the materialized view definition
  • ora-24357 : internal error while converting from to OCIDate.
  • ora-14641 : STORE-IN clause can be specified only for a Hash, Composite Range Hash table/partition
  • ora-00221 : error on write to control file
  • ora-32163 : Method called on Invalid Environment type
  • ora-17610 : file 'string' does not exist and no size specified
  • ora-10572 : Test recovery canceled due to errors
  • ora-02420 : missing schema authorization clause
  • ora-09291 : sksachk: invalid device specified for archive destination
  • ora-01125 : cannot disable media recovery - file string has online backup set
  • ora-13182 : failed to read element string.string.string
  • ora-39772 : column array reset disallowed after OCI_CONTINUE or OCI_NEED_DATA
  • ora-29298 : Character set mismatch
  • ora-32124 : Illegal attribute passed
  • ora-24010 : QUEUE string does not exist
  • ora-25019 : too much concurreny
  • ora-30332 : container table already in use by other summary
  • ora-01146 : cannot start online backup - file string is already in backup
  • ora-07238 : slemcl: close error.
  • ora-19719 : length for operation name longer than string
  • ora-16567 : Data Guard broker internal parser error at "string"
  • ora-00449 : background process 'string' unexpectedly terminated with error string
  • 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.