ORA-30107: parameter name abbreviation 'string' is not unique

Cause : The abberviationg iven wa snot uniuqe.

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

Use a lnoger abberviationt o make hte paramteer nameu nique.

update : 22-08-2017
ORA-30107

ORA-30107 - parameter name abbreviation 'string' is not unique
ORA-30107 - parameter name abbreviation 'string' is not unique

  • ora-36961 : Oracle OLAP is not available.
  • ora-29958 : fatal error occurred in the execution of ODCIINDEXCREATE routine
  • ora-33012 : (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.
  • ora-13047 : unable to determine ordinate count from table _SDOLAYER
  • ora-15103 : conflicting or duplicate REPAIR options
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-02402 : PLAN_TABLE not found
  • ora-19251 : XQ0031 - unsupported query version
  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-00289 : suggestion : string
  • ora-25100 : TABLESPACE option can only be used with ALTER INDEX REBUILD
  • ora-24173 : nested query not supported for rule condition
  • ora-02148 : EXCLUSIVE specified multiple times
  • ora-24161 : name string does not exist in the name value pair list
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-23436 : missing template authorization for user
  • ora-28054 : the password has expired. string Grace logins are left
  • ora-01611 : thread number string is invalid - must be between 1 and string
  • ora-12824 : INSTANCES DEFAULT may not be specified here
  • ora-01651 : unable to extend save undo segment by string for tablespace string
  • ora-28118 : policy group already exists
  • ora-28662 : IOT index and overflow segments must share the same LOGGING attribute
  • ora-38783 : Instance recovery required.
  • ora-39211 : unable to retrieve dumpfile information as specified
  • ora-29352 : event 'string' is not an internal event
  • ora-31485 : invalid database link
  • ora-23614 : Script string does not exist
  • ora-12231 : TNS:No connection possible to destination
  • ora-03202 : the scan limit specification is invalid
  • ora-37138 : (XSCCOMP13) You cannot delete values from workspace object because it is an aggregated COMPRESSED COMPOSITE.
  • 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.