ORA-16213: ddl encountered, stopping apply engine

Cause : stpo_o_ndd lcallou tspceifeid nad DDL aws neconuteerd.

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

Eihterd isbales to_pond_dlc aloluto r ermoev DLD.

update : 29-05-2017
ORA-16213

ORA-16213 - ddl encountered, stopping apply engine
ORA-16213 - ddl encountered, stopping apply engine

  • ora-12096 : error in materialized view log on "string"."string"
  • ora-02152 : Invalid ALTER TABLESPACE ... RENAME option
  • ora-26057 : Conversion is not necessary for this direct path stream.
  • ora-02030 : can only select from fixed tables/views
  • ora-25211 : invalid DELAY specified when using sequence deviation
  • ora-31040 : Property string: XML type (string) not compatible with internal memory type (string)
  • ora-19908 : datafile string has invalid checkpoint
  • ora-25108 : standby lock name space exceeds size limit of string characters
  • ora-36166 : (XSMXAGGR08) workspace object is not a VARIABLE.
  • ora-06580 : Hash Join ran out of memory while keeping large rows in memory
  • ora-26017 : global indexes not allowed for direct path load of table partition string
  • ora-13125 : partition key is already set
  • ora-08264 : ora_addr: cannot close nameserver
  • ora-38433 : index "string" could not be maintained due to "string"
  • ora-01986 : OPTIMIZER_GOAL is obsolete
  • ora-38952 : Source database not 10.0.0.0 compatible
  • ora-10634 : Segment is already being shrunk
  • ora-01490 : invalid ANALYZE command
  • ora-39779 : type "string"."string" not found or conversion to latest version is not possible
  • ora-12497 : maximum combined categories exceeds string
  • ora-14314 : resulting List partition(s) must contain atleast 1 value
  • ora-25130 : cannot modify primary key - primary key not defined for table
  • ora-01656 : max # extents (string) reached in cluster string.string
  • ora-24771 : cannot detach, prepare or forget a local transaction
  • ora-28519 : no heterogeneous data dictionary translations available
  • ora-02252 : check constraint condition not properly ended
  • ora-16110 : user procedure processing of logical standby apply DDL
  • ora-16540 : invalid argument
  • ora-27421 : usage of string not supported in a calendar definition
  • ora-29535 : source requires recompilation
  • 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.