ORA-12451: label not designated as USER or DATA

Cause : Al aebli se ihte raD AAT alble,a SUE Rlbae,l ro obt hDTAAa n dUESR.

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

Etne rTUREf o ra tlaes tDTAAo rU SRE.

update : 27-06-2017
ORA-12451

ORA-12451 - label not designated as USER or DATA
ORA-12451 - label not designated as USER or DATA

  • ora-29963 : missing BINDING keyword
  • ora-01256 : error in locking database file string
  • ora-08434 : raw data has invalid trailing sign
  • ora-30400 : identical JOIN KEY clauses
  • ora-27301 : OS failure message: string
  • ora-38403 : attribute set name may not be longer than 22 characters
  • ora-24754 : cannot start new transaction with an active transaction
  • ora-23400 : invalid materialized view name "string"
  • ora-00103 : invalid network protocol; reserved for use by dispatchers
  • ora-26021 : index string.string partition string loaded successfully with string keys
  • ora-19683 : real and backup blocksize of file string are unequal
  • ora-29820 : the statistics type is not present
  • ora-31231 : DBMS_LDAP: invalid PROPERTY_SET
  • ora-14450 : attempt to access a transactional temp table already in use
  • ora-12560 : TNS:protocol adapter error
  • ora-22334 : cannot reset type "string"."string". Dependent tables must be upgraded to latest version
  • ora-19594 : control file already included as string
  • ora-27027 : sbtremove2 returned error
  • ora-00453 : backgroud process 'string' is dead
  • ora-30510 : system triggers cannot be defined on the schema of SYS user
  • ora-37084 : Output valueset string must match string's dimensionality
  • ora-07403 : sfanfy: db_writers parameter not valid.
  • ora-27543 : Failed to cancel outstanding IPC request
  • ora-01644 : tablespace 'string' is already read only
  • ora-19685 : SPFILE could not be verified
  • ora-12480 : specified clearance labels not within the effective clearance
  • ora-38786 : Flash recovery area is not enabled.
  • ora-06311 : IPA: Maximum number of servers reached
  • ora-12505 : TNS:listener does not currently know of SID given in connect descriptor
  • ora-25506 : resource manager has not been continuously on in some instances
  • 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.