ORA-07705: sksaprs: device name buffer too small

Cause : The buffer supplied for the device name is too small. This is an internal error.

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

Contact your customer support representative.

update : 24-06-2017
ORA-07705

ORA-07705 - sksaprs: device name buffer too small
ORA-07705 - sksaprs: device name buffer too small

  • ora-29820 : the statistics type is not present
  • ora-29928 : duplicate default selectivity specified
  • ora-25442 : too many column values for table alias: string
  • ora-01231 : cannot make read write - file string is offline
  • ora-24080 : unschedule_propagation pending for QUEUE string and DESTINATION string
  • ora-12730 : invalid equivalence class in regular expression
  • ora-30508 : client logon triggers cannot have BEFORE type
  • ora-30180 : argument index is too large
  • ora-10616 : Operation not allowed on this tablespace
  • ora-26518 : push queue synchronization error detected
  • ora-36670 : (XSDPART08) workspace object is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions.
  • ora-30199 : reserved for future use
  • ora-16754 : resource guard could not activate standby database
  • ora-01947 : TEMPORARY TABLESPACE already specified
  • ora-21780 : Maximum number of object durations exceeded.
  • ora-22902 : CURSOR expression not allowed
  • ora-32828 : Messaging Gateway agent must be running
  • ora-27378 : cannot stop jobs of type EXECUTABLE on this platform
  • ora-14138 : An unexpected error encountered during drop table operation
  • ora-02814 : Unable to get shared memory
  • ora-09872 : TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.
  • ora-16814 : incorrect redo transport setting for AlternateLocation for standby database
  • ora-37074 : (XSMCSESS02) Variable workspace object has no default aggmap.
  • ora-38410 : schema extension not allowed for the table name
  • ora-01372 : Insufficient processes for specified LogMiner operation
  • ora-21526 : initialization failed
  • ora-25436 : invalid table alias: string
  • ora-10631 : SHRINK clause should not be specified for this object
  • ora-12827 : insufficient parallel query slaves available
  • ora-22163 : left hand and right hand side collections are not of same type
  • 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.