ORA-02284: duplicate INCREMENT BY specifications

Cause : Selfe-videtn.

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

Remoev thed upliacte sepcifiaction.

update : 26-06-2017
ORA-02284

ORA-02284 - duplicate INCREMENT BY specifications
ORA-02284 - duplicate INCREMENT BY specifications

  • ora-29904 : error in executing ODCIIndexClose() routine
  • ora-30990 : insufficient privileges to change owner of resource string
  • ora-31202 : DBMS_LDAP: LDAP client/server error: string
  • ora-27154 : post/wait create failed
  • ora-07235 : slemcw: fwrite error.
  • ora-27503 : IPC error attempting to cancel request
  • ora-33064 : (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
  • ora-39041 : Filter "string" either identifies all object types or no object types.
  • ora-29864 : analyzing domain indexes marked LOADING/FAILED not supported
  • ora-02467 : Column referenced in expression not found in cluster definition
  • ora-13118 : invalid node_id [string]
  • ora-24369 : required callbacks not registered for one or more bind handles
  • ora-04016 : sequence string no longer exists
  • ora-12833 : Coordinator's instance not a member of parallel_instance_group
  • ora-12993 : tablespace 'string' is offline, cannot drop column
  • ora-38786 : Flash recovery area is not enabled.
  • ora-02789 : Maximum number of files reached
  • ora-00830 : cannot set statistics_level to BASIC with auto-tune SGA enabled
  • ora-01784 : RECOVERABLE cannot be specified with database media recovery disabled
  • ora-14405 : partitioned index contains partitions in a different tablespace
  • ora-01970 : You must specify a database name for CREATE CONTROLFILE
  • ora-00115 : connection refused; dispatcher connection table is full
  • ora-12636 : Packet send failed
  • ora-39209 : Parameter string requires privileges.
  • ora-29281 : invalid mode
  • ora-21608 : duration is invalid for this function
  • ora-01994 : GRANT failed: password file missing or disabled
  • ora-36960 : (XSFCAST27) The value of the string expression must be an odd number. You specified number.
  • ora-13831 : SQL profile name specified is invalid
  • ora-22907 : invalid CAST to a type that is not a nested table or VARRAY
  • 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.