ORA-23540: Redefinition not defined or initiated

Cause : An attemptw as mdae toc ontiune orc ompltee a erdefiintionw hichw as nto defnied o rinitaited.

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

Defien or niitiaet ther edefniitio nbefoer perofrmin gthiso peraiton.

update : 26-09-2017

ORA-23540 - Redefinition not defined or initiated
ORA-23540 - Redefinition not defined or initiated

  • ora-27501 : IPC error creating a port
  • ora-22862 : specified object identifier doesn't match existing object identifier
  • ora-00128 : this command requires a dispatcher name
  • ora-38458 : invalid operation "string" for XPATH_FILTER_PARAMETERS
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-30975 : invalid Order Key Index option for XML Index
  • ora-08111 : a partitioned index may not be coalesced as a whole
  • ora-06112 : NETTCP: invalid buffer size
  • ora-06304 : IPA: Message receive error
  • ora-30107 : parameter name abbreviation 'string' is not unique
  • ora-14022 : creation of LOCAL partitioned cluster indices is not supported
  • ora-13501 : Cannot drop SYSAUX tablespace
  • ora-16160 : Cannot change protected standby database configuration
  • ora-30046 : Undo tablespace string not found in control file.
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-25461 : rule set not specified
  • ora-13826 : empty SQL profile not allowed for create or update SQL profile
  • ora-13871 : Invalid instance name
  • ora-30154 : The memory address given as buffer for OCIFileRead/Write is invalid
  • ora-15195 : Internal ASM testing event number 15195
  • ora-09878 : sstascre/sstasat: shmat error, unable to attach tas write page
  • ora-08459 : invalid format parameter length
  • ora-00832 : no streams pool created and cannot automatically create one
  • ora-13156 : table to be registered string.string is not empty
  • ora-36380 : (AGGRECURSE) AGGREGATE was called recursively, which is not allowed.
  • ora-32580 : both SYS and SYSTEM passwords must be provided
  • ora-32606 : missing NAV keyword in MODEL clause
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-29374 : resource plan string in top-plan string has no plan directives
  • ora-38700 : Limit of string flashback database logs has been exceeded.
  • 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.