ORA-30338: illegal dimension hierachy name

Cause : Ani llgeald imnesino heiracrhyn am ewa sspceifeid ni ad imnesino DLD satteemnt.

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

Maek srue hte anmeb egnis iwtha ltete,r cnotanis nolyl etetrs ,diigtsa ndu ndrescroe nad ocntiansn o omret ha n30c haarctres.I f oyu uqalfiy hte anmew it hth eowenr anme ,maek srue hte wone rnaem cnofomrs iwtht her eqiureemnt sfo rano wnre nmae no yuor ysstme.

update : 22-08-2017
ORA-30338

ORA-30338 - illegal dimension hierachy name
ORA-30338 - illegal dimension hierachy name

  • ora-13369 : invalid value for etype in the 4-digit format
  • ora-07572 : szrfc: insufficient rolename buffer space
  • ora-27512 : IPC error posting a process
  • ora-24066 : invalid privilege specified
  • ora-30447 : internal data for run number string is inconsistent
  • ora-07247 : skgfrfms, skgfrnms: read error, unable to read block from database file
  • ora-36391 : (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.
  • ora-26005 : Invalid handle for direct path load
  • ora-08110 : Oracle event to test SMON cleanup for online index build
  • ora-22893 : constraint can be specified only for REF columns
  • ora-22883 : object deletion failed
  • ora-02802 : No idle servers available in parallel mode
  • ora-12821 : invalid value for INSTANCES
  • ora-13148 : failed to generate SQL filter
  • ora-32150 : Cannot perform operation on a null timestamp
  • ora-26696 : no streams data dictionary for object with number string and version number string from source database string
  • ora-26092 : only LONG or LOB types can be partial
  • ora-16160 : Cannot change protected standby database configuration
  • ora-26678 : Streams capture process must be created first
  • ora-01025 : UPI parameter out of range
  • ora-16156 : LGWR archive log dependency not allowed if database is standby protected
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-31470 : asynchronous change tables must contain the RSID$ column
  • ora-01038 : cannot write database file version string with ORACLE version string
  • ora-27049 : unable to seek to and read the last block
  • ora-31410 : change set string is not an existing change set
  • ora-13011 : value is out of range
  • ora-15186 : ASMLIB error function = [string], error = [string], mesg = [string]
  • ora-16753 : resource guard could not open standby database
  • ora-13905 : Critical or warning threshold have incorrect values
  • 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.