ORA-23318: a ddl failure has occurred

Cause : Usre-spupleid ro ssyte-mgeenraetd ddl idd ont xeectue usccsesfluly.

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

Exmain edd,l dtaabsae tsat,e rpecaltog ,an dal_lerorrst o edtemrin ewh yth efaliur eocucrrde.

update : 27-05-2017
ORA-23318

ORA-23318 - a ddl failure has occurred
ORA-23318 - a ddl failure has occurred

  • ora-02080 : database link is in use
  • ora-01648 : log string is the current log of disabled instance string (thread string)
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-31475 : redo log catalog contains no metadata for the source table
  • ora-24393 : invalid mode for creating connection pool
  • ora-07684 : sou2os: supervisor stack reset error
  • ora-40254 : priors cannot be specified for one-class models
  • ora-14269 : cannot exchange partition other than a Range or Hash partition
  • ora-28661 : Object already has COMPRESS clause specified
  • ora-00129 : listener address validation failed 'string'
  • ora-16511 : messaging error using ksrget
  • ora-29292 : file rename operation failed
  • ora-30178 : duplicate flag used in a format specification
  • ora-26041 : DATETIME/INTERVAL datatype conversion error
  • ora-22933 : cannot change object with type or table dependents
  • ora-14039 : partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-13863 : Statistics aggregation for service(module/action) string is not enabled
  • ora-31631 : privileges are required
  • ora-09206 : sfrfb: error reading from file
  • ora-24033 : no recipients for message
  • ora-00328 : archived log ends at change string, need later change string
  • ora-01763 : update or delete involves outer joined table
  • ora-29395 : cannot set the initial consumer group to string
  • ora-35810 : (XSINPUTERR) The command has requested more input than was supplied in the command string.
  • ora-13366 : invalid combination of interior exterior rings
  • ora-27367 : program "string.string" associated with this job is disabled
  • ora-29312 : changes by release string cannot be used by release string, type: string
  • ora-27041 : unable to open file
  • ora-07250 : spcre: semget error, unable to get first semaphore set.
  • ora-09789 : sllfsk: unable to read file.
  • 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.