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 : 22-07-2017
ORA-23318

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

  • ora-00310 : archived log contains sequence string; sequence string required
  • ora-00079 : variable string not found
  • ora-01268 : invalid TEMPFILE clause for alter of permanent TABLESPACE
  • ora-10616 : Operation not allowed on this tablespace
  • ora-12438 : repeated policy option: string
  • ora-32144 : Cannot perform operation on a null interval
  • ora-13705 : There was a instance shutdown/startup between the snapshots in the range [string, string].
  • ora-27073 : Trying to close a file which has async I/Os pending to be dequeued
  • ora-01260 : warning: END BACKUP succeeded but some files found not to be in backup mode
  • ora-14512 : cannot perform operation on a clustered object
  • ora-06113 : NETTCP: Too many connections
  • ora-06006 : NETASY: dialogue execute failure
  • ora-07345 : The datafile name must not contain the string '..'.
  • ora-02202 : no more tables permitted in this cluster
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-06443 : ssvpstev: Incorrect parameter passed to function call
  • ora-16241 : Waiting for gap logfile (thread# string, sequence# string)
  • ora-09940 : ORACLE password file header is corrupt
  • ora-12533 : TNS:illegal ADDRESS parameters
  • ora-29856 : error occurred in the execution of ODCIINDEXDROP routine
  • ora-12703 : this character set conversion is not supported
  • ora-06816 : TLI Driver: could not set the SPX SAP address
  • ora-16740 : redo transport service for standby database "string" incorrectly set to ALTERNATE
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-01771 : illegal option for a clustered table
  • ora-24358 : OCIBindObject not invoked for a Object type or Reference
  • ora-31519 : CDC subscription string already exists
  • ora-25014 : cannot change the value of a PARENT reference variable
  • ora-12601 : TNS:information flags check failed
  • ora-33267 : (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it
  • 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.