ORA-31662: metadata transform name can not be defaulted

Cause : A null metadata transform name was supplied.

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

Fix the call to specify a metadata transform name.

update : 27-05-2017

ORA-31662 - metadata transform name can not be defaulted
ORA-31662 - metadata transform name can not be defaulted

  • ora-34243 : (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
  • ora-13776 : User "string" has not been granted the "SELECT" privilege on the "SQL tuning set" DBA views.
  • ora-23318 : a ddl failure has occurred
  • ora-22054 : underflow error
  • ora-27465 : invalid value string for attribute string
  • ora-29828 : invalid name for implementation type
  • ora-24318 : call not allowed for scalar data types
  • ora-31423 : change table string does not contain column string
  • ora-39022 : Database version string is not supported.
  • ora-10920 : Cannot offline tablespace belonging to default temporary tablespace group
  • ora-01573 : shutting down instance, no further change allowed
  • ora-29867 : cannot create a domain index on a LONG column
  • ora-40220 : maximum number of attributes exceeded
  • ora-30455 : summary contains VARIANCE without corresponding SUM & COUNT
  • ora-06970 : X.25 Driver: remote host is unknown
  • ora-08447 : syntax error in USAGE clause in mask options
  • ora-14612 : Duplicate lob segment name string for lob column string in template
  • ora-30069 : Auto Undo-Management Error simulation - test site = string
  • ora-09857 : smprset: vm_protect error while protecting pga.
  • ora-19953 : database should not be open
  • ora-24408 : could not generate unique server group name
  • ora-06042 : NETDNT: message receive failure
  • ora-13449 : GeoRaster metadata ULTCoordinate error
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-13860 : Invalid service name
  • ora-38463 : invalid XML Tag list
  • ora-23386 : replication parallel push cannot create slave processes
  • ora-23430 : argument "string" cannot be NULL or empty string
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-13233 : failed to create sequence number [string] for R-tree
  • 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.