ORA-22304: input type is not an object type

Cause : hT esurei srtiygnt oboatnit ehs pureytepi fnroamitnof roa n noo-jbce tytep.

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

aPssi nnoyla nboejtct py.e

update : 28-04-2017

ORA-22304 - input type is not an object type
ORA-22304 - input type is not an object type

  • ora-31198 : Mismatch in number of bytes transferred due to non-binary mode
  • ora-06408 : NETCMN: incorrect message format
  • ora-01969 : You must specify RESETLOGS or NORESETLOGS
  • ora-01522 : file 'string' to be renamed does not exist
  • ora-10931 : trace name context forever
  • ora-12405 : invalid label list
  • ora-31419 : source table string does not exist
  • ora-01926 : cannot GRANT to a role WITH GRANT OPTION
  • ora-25186 : INCLUDING clause specified for index-organized table without OVERFLOW
  • ora-15055 : unable to connect to ASM instance
  • ora-00397 : instance recovery process terminated with error
  • ora-01507 : database not mounted
  • ora-36276 : (XSCGMDLAGG06) The current operator does not need a weight variable.
  • ora-02358 : internal error fetching attribute string
  • ora-23341 : user function required
  • ora-24240 : invalid database access descriptor (DAD) name
  • ora-06436 : ssaio: asynchronous I/O failed due to incorrect parameters.
  • ora-12914 : Cannot migrate tablespace to dictionary managed type
  • ora-23414 : materialized view log for "string"."string" does not record rowid values
  • ora-09834 : snyGetPortSet: failed to collect info on a port.
  • ora-09882 : sstasfre/sstasdel: shmctl error, unable to remove tas shm page
  • ora-09957 : Unable to send termination request to IMON
  • ora-24275 : function 'string' parameter 'string' missing or invalid
  • ora-38498 : invalid stored attribute for the index object : string
  • ora-02495 : cannot resize file string, tablespace string is read only
  • ora-32802 : value for string must be string
  • ora-38505 : invalid default value for the attribute
  • ora-13372 : failure in modifying metadata for a table with spatial index
  • ora-27091 : unable to queue I/O
  • ora-36170 : (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not 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.