ORA-02466: The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.

Cause : An attmept wasm ade toc hange hte SIZEa nd INIRTANS opitons afetr the ahsh clutser wasc reated.

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

Do nots pecifyt his opiton.

update : 24-06-2017
ORA-02466

ORA-02466 - The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.
ORA-02466 - The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.

  • ora-14519 : Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]
  • ora-39139 : Data Pump does not support XMLSchema objects. string will be skipped.
  • ora-12318 : database (link name string) is already mounted
  • ora-16561 : cannot remove an active instance
  • ora-13639 : The current operation was interrupted because it timed out.
  • ora-00202 : control file: 'string'
  • ora-00292 : parallel recovery feature not installed
  • ora-29292 : file rename operation failed
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-19911 : datafile string contains future changes at the incarnation boundary
  • ora-27544 : Failed to map memory region for export
  • ora-32504 : expecting one of string, string, string, or string but found string
  • ora-13606 : the specified task parameter element string is out of range for parameter string.
  • ora-06407 : NETCMN: unable to set up break handling environment
  • ora-03128 : connection is in blocking mode
  • ora-25003 : cannot change NEW values for this column type in trigger
  • ora-07474 : snclrd: close error, unable to close sgadef.dbf file.
  • ora-06709 : TLI Driver: message send failure
  • ora-30461 : 'string.string' cannot be refreshed because it is marked DISABLED
  • ora-31212 : DBMS_LDAP: PL/SQL - Invalid LDAP mod_array.
  • ora-12072 : updatable materialized view log data for "string"."string" cannot be created
  • ora-29277 : invalid SMTP operation
  • ora-39138 : Insufficient privileges to load data not in your schema
  • ora-24430 : Null values for sqltext and key were specified.
  • ora-06035 : NETDNT: connect failed, insufficient resources
  • ora-38493 : feature not enabled : Expression Filter index
  • ora-25264 : cant get signature for this queue
  • ora-39762 : streams must be loaded in conversion order
  • ora-38732 : Expected file size string does not match 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.