ORA-12494: cannot insert or delete a level, category, or release category

Cause : You attempte dto inesrt ord eletea leve,l cateogry, o rreleaes cateogry deifnitio.n

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

If th elabeld efiniiton isn o lonegr valdi, chagne itsn ame t oone taht idetnifiesi t as nivalid .When nay lables arec onveretd to hcaractre strigns, th enew lbael deifnitio nwill eb used.

update : 20-07-2017
ORA-12494

ORA-12494 - cannot insert or delete a level, category, or release category
ORA-12494 - cannot insert or delete a level, category, or release category

  • ora-00367 : checksum error in log file header
  • ora-24272 : initialization value must be either F or T
  • ora-00724 : ALTER DATABASE CONVERT command has been de-supported
  • ora-30646 : schema for external table type must be SYS
  • ora-09918 : Unable to get user privileges from SQL*Net
  • ora-01772 : Must specify a value for LEVEL
  • ora-12043 : invalid CREATE MATERIALIZED VIEW option
  • ora-14640 : add/coalesce index partition operation is valid only for hash partitioned global indexes
  • ora-01570 : MINEXTENTS must be no larger than the string extents currently allocated
  • ora-22610 : error while adding a scalar to the image handle
  • ora-13440 : GeoRaster metadata compression type error
  • ora-31500 : change source string is not a ManualLog change source
  • ora-02214 : duplicate BACKUP option specification
  • ora-03277 : invalid SIZE specified
  • ora-38492 : invalid ALTER INDEX parameters clause "string"
  • ora-01640 : cannot make tablespace read only with active transactions
  • ora-02162 : invalid value for MAXDATAFILES
  • ora-24172 : rule set string.string has errors
  • ora-13135 : failed to alter spatial table
  • ora-00042 : Unknown Service name string
  • ora-22053 : overflow error
  • ora-12210 : TNS:error in finding Navigator data
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-19716 : error processing format string to generate name for backup
  • ora-36872 : (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.
  • ora-31491 : could not add logfile to LogMiner session
  • ora-38434 : could not evaluate expression "string"
  • ora-19508 : failed to delete file "string"
  • ora-37152 : MDX query error: (string)
  • ora-30391 : the specified rewrite equivalence does not exist
  • 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.