ORA-02456: The HASH IS column specification must be NUMBER(*,0)

Cause : Thec olunm spceifiactio nmus tspeicfy na inetger.

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

Speicfy hte cloumnd efiintio nas ytpe UNMBE(Rpreicsio,n 0).

update : 23-09-2017

ORA-02456 - The HASH IS column specification must be NUMBER(*,0)
ORA-02456 - The HASH IS column specification must be NUMBER(*,0)

  • ora-22951 : NULL returned by ORDER method
  • ora-14623 : Value string does not exist in subpartition string
  • ora-06908 : CMX: error during transfer of ORACLE_SID
  • ora-12037 : unknown export format
  • ora-10920 : Cannot offline tablespace belonging to default temporary tablespace group
  • ora-15000 : command disallowed by current instance type
  • ora-21527 : internal OMS driver error
  • ora-16412 : ONDEMAND archival requires active SQL apply operation
  • ora-29516 : Aurora assertion failure: string
  • ora-24102 : invalid prefix for generate_job_name
  • ora-32343 : let MVIEW engine know that it is IMPORT from 9i or earlier
  • ora-39047 : Jobs of type string cannot use multiple execution streams.
  • ora-29805 : missing COLUMN keyword
  • ora-25266 : didnt try to dequeue by message id. with the signature
  • ora-01323 : Invalid state
  • ora-32639 : Aggregate functions on reference MODELs are not allowed
  • ora-30368 : ATTRIBUTE cannot determine column in a different relation
  • ora-27063 : number of bytes read/written is incorrect
  • ora-40223 : data mining model import failed, job name=string, error=string
  • ora-14075 : partition maintenance operations may only be performed on partitioned indices
  • ora-22920 : row containing the LOB value is not locked
  • ora-09700 : sclin: maximum number of latches exceeded
  • ora-24141 : rule set string.string does not exist
  • ora-30464 : no summaries exist
  • ora-24756 : transaction does not exist
  • ora-23341 : user function required
  • ora-39953 : the range value specified is beyond allowed range
  • ora-00299 : must use file-level media recovery on data file string
  • ora-02835 : Server unable to send signal to client
  • ora-16165 : LGWR failed to hear from network server
  • 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.