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 : 23-09-2017
ORA-23318

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

  • ora-13636 : The specified value provided for parameter string is not valid for this advisor.
  • ora-08451 : invalid specification of DB in picture mask
  • ora-15059 : invalid device type for ASM disk
  • ora-25113 : GLOBAL may not be used with a bitmap index
  • ora-39179 : unable to load table "string"."string" because of OID transform
  • ora-19637 : backupPieceCreate requires file name when using DISK device
  • ora-01148 : cannot refresh file size for datafile string
  • ora-31510 : name uses reserved prefix CDC$
  • ora-29260 : network error: string
  • ora-32106 : array fetch not allowed without setBuffer on all columns
  • ora-37116 : OLAP API table function error: (string)
  • ora-04046 : results of compilation are too large to support
  • ora-14265 : data type or length of a table subpartitioning column may not be changed
  • ora-16185 : REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive
  • ora-31457 : maximum length of description field exceeded
  • ora-16790 : the value of the configurable property is invalid
  • ora-30335 : JOIN KEY clause references a level not in this hierarchy
  • ora-16114 : applying DDL transaction with commit SCN string
  • ora-02766 : Invalid maximum of request descriptors
  • ora-28004 : invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
  • ora-06523 : Maximum number of arguments exceeded
  • ora-29382 : validation of pending area failed
  • ora-09880 : sstasfre/sstasdel: shmdt error, unable to detach tas write page
  • ora-15027 : active use of diskgroup "string" precludes its dismount
  • ora-30078 : partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
  • ora-28022 : cannot grant external roles to global user or role
  • ora-01649 : operation not allowed with a backup control file
  • ora-24433 : This statement has already been prepared using OCIStmtPrepare2.
  • ora-16635 : NetSlave connection was broken in the middle of a transmission session
  • ora-01336 : specified dictionary file cannot be opened
  • 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.