ORA-24051: cannot propagate object type payloads that have a REF attribute

Cause : A nADD_USBCSRBIE Ro rEQNUUEEp rcoeudr ewtiha onnN-ULL daders sfeil di nteh gaetn ytp ewsa siseudo na uqeeu hwoes apyola dhsa aRFE tatirbtue .Porpgaaito no fojbetc ytp epyalaod stahth aev aRFE tatirbtuec urretnl yi snto uspopretd.

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

Sepcfiya na gnetw iht aNLULa drdess ifedl os hta tteh gaetn acnd euqeeu rfo mteh asm eqeuu.e rO,c hnag eteh bojcett yep edfniiito nt ooen hta tdeosn o tues ERFa trtiubtse.

update : 23-05-2017

ORA-24051 - cannot propagate object type payloads that have a REF attribute
ORA-24051 - cannot propagate object type payloads that have a REF attribute

  • ora-01247 : database recovery through TSPITR of tablespace string
  • ora-19593 : datafile number string already included as string
  • ora-06403 : Unable to allocate memory.
  • ora-25131 : cannot modify unique(string) - unique key not defined for table
  • ora-22344 : can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
  • ora-24813 : cannot send or receive an unsupported LOB
  • ora-29310 : database is not open, or opened as a clone
  • ora-06766 : TLI Driver: close failed during release
  • ora-09797 : Failed to get O/S MAC privileges.
  • ora-28011 : the account will expire soon; change your password now
  • ora-09925 : Unable to create audit trail file
  • ora-30502 : system triggers cannot have INSERT, UPDATE, or DELETE as triggering events
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-15111 : conflicting or duplicate STRIPE options
  • ora-22333 : cannot reset type "string"."string" due to invalid dependent types and tables
  • ora-12856 : cannot run parallel query on a loopback connection
  • ora-27040 : file create error, unable to create file
  • ora-07222 : slspool: line printer spooler command exited with an error.
  • ora-13634 : The task string needs to be reset before being re-executed.
  • ora-28660 : Partitioned Index-Organized table may not be MOVEd as a whole
  • ora-16506 : out of memory
  • ora-31050 : Access denied
  • ora-03237 : Initial Extent of specified size cannot be allocated in tablespace (string)
  • ora-07624 : smsdes: $DGBLSC failure
  • ora-13402 : the rasterType is null or not supported
  • ora-12646 : Invalid value specified for boolean parameter
  • ora-07405 : sptrap: cannot setup alternate signal stack.
  • ora-10568 : Failed to allocate recovery state object: out of SGA memory
  • ora-29391 : %s and string must be mandatory to create a mandatory plan directive
  • ora-24169 : rule condition has unrecognized variables
  • 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.