ORA-27452: %s is an invalid name for a database object.

Cause : An invlaid nam ewas usde to idnetify ad atabas eobject.

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

Reissu ethe command usnig a vaild name.

update : 24-08-2017
ORA-27452

ORA-27452 - %s is an invalid name for a database object.
ORA-27452 - %s is an invalid name for a database object.

  • ora-02396 : exceeded maximum idle time, please connect again
  • ora-25009 : Nested table clause allowed only for INSTEAD OF triggers
  • ora-19763 : compatibility version string is higher than maximum allowed: string
  • ora-16406 : Primary and standby database software version mismatch
  • ora-19112 : error raised during evaluation: string
  • ora-02256 : number of referencing columns must match referenced columns
  • ora-24312 : illegal parameters specified for allocating user memory
  • ora-12417 : database object "string" not found
  • ora-22343 : Compilation error for type invalidated by ALTER TYPE
  • ora-07635 : smsdbp: $SETPRT failure
  • ora-22063 : reading negative value [string] as unsigned
  • ora-29884 : domain index is defined on the column to be dropped
  • ora-25448 : rule string.string has errors
  • ora-01030 : SELECT ... INTO variable does not exist
  • ora-40251 : no support vectors were found
  • ora-29318 : datafile string is online
  • ora-26026 : unique index string.string initially in unusable state
  • ora-30163 : The thread safety initialization failed
  • ora-01019 : unable to allocate memory in the user side
  • ora-12672 : Database logon failure
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-39114 : Dump files are not supported for network jobs.
  • ora-26711 : remote table does not contain a primary key constraint
  • ora-32300 : cannot drop a secondary materialized view "string"."string"
  • ora-10579 : Can not modify control file during test recovery
  • ora-02825 : Request on free list was not free
  • ora-30452 : cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)
  • ora-30933 : Element 'string' may not appear at this point within parent 'string'
  • ora-14518 : partition contains rows corresponding to values being dropped
  • ora-36341 : (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)
  • 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.