ORA-13418: null or invalid parameter(s) for set functions

Cause : A apraemte rfo rse tmeatdaat oepraiton swa snull o rinavli.d

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

Chcek hte odcuemnttaio nfo rinofrmtaio nabuot hte apraemtesr.

update : 28-06-2017

ORA-13418 - null or invalid parameter(s) for set functions
ORA-13418 - null or invalid parameter(s) for set functions

  • ora-26675 : cannot create Streams capture process string
  • ora-01601 : illegal bucket size in clause "string" of string
  • ora-31407 : end_date must be greater than the begin_date
  • ora-01031 : insufficient privileges
  • ora-31671 : Worker process string had an unhandled exception.
  • ora-29362 : plan directive string, string does not exist
  • ora-13791 : cannot resume a tuning task created to tune a single statement
  • ora-00214 : control file 'string' version string inconsistent with file 'string' version string
  • ora-06748 : TLI Driver: cannot allocate t_discon
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-31495 : error in synchronous change table on "string"."string"
  • ora-14036 : partition bound value too large for column
  • ora-16239 : IMMEDIATE option not available without standby redo logs
  • ora-01451 : column to be modified to NULL cannot be modified to NULL
  • ora-06035 : NETDNT: connect failed, insufficient resources
  • ora-27546 : Oracle compiled against IPC interface version string.string found version string.string
  • ora-40209 : setting % is invalid for % function
  • ora-19923 : the session for row with id string is not active
  • ora-14082 : new partition name must differ from that of any other partition of the object
  • ora-38777 : database must not be started in any other instance.
  • ora-30014 : operation only supported in Automatic Undo Management mode
  • ora-14461 : cannot REUSE STORAGE on a temporary table TRUNCATE
  • ora-01273 : STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = string or higher
  • ora-00965 : column aliases not allowed for '*'
  • ora-16762 : invalid database state
  • ora-29704 : cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release
  • ora-39078 : unable to dequeue message for agent string from queue "string"
  • ora-37137 : (XSCCOMP12) You cannot CHGDFN workspace object because it is a COMPRESSED COMPOSITE.
  • ora-25307 : Enqueue rate too high, flow control enabled
  • ora-30747 : cannot create substitutable tables or columns of non final type string.string
  • 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.