ORA-28025: missing or null external name

Cause : The IDENTIFIED EXTERNALLY AS or IDENTIFIED GLOBALLY AS clause was specified with a valid external name.

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

Provide a valid external name.

update : 30-04-2017
ORA-28025

ORA-28025 - missing or null external name
ORA-28025 - missing or null external name

  • ora-08008 : another instance is mounted with USE_ROW_ENQUEUES = string
  • ora-19772 : change tracking file name exceeds limit of string characters
  • ora-08313 : sllfop: could not allocate buffers
  • ora-39179 : unable to load table "string"."string" because of OID transform
  • ora-24319 : unable to allocate memory
  • ora-02060 : select for update specified a join of distributed tables
  • ora-38727 : FLASHBACK DATABASE requires a current control file.
  • ora-25466 : data not specified for variable name: string
  • ora-31688 : Worker process string failed during startup.
  • ora-14138 : An unexpected error encountered during drop table operation
  • ora-38468 : column "string" is not identified as a column storing expressions.
  • ora-32109 : invalid column or parameter position
  • ora-15196 : invalid ASM block header [string:string] [string] [string] [string] [string != string]
  • ora-16821 : logical standby database dictionary not yet loaded
  • ora-10585 : Test recovery can not apply redo that may modify control file
  • ora-12165 : TNS:Trying to write trace file into swap space.
  • ora-40107 : operation requires string option to be installed
  • ora-01031 : insufficient privileges
  • ora-27023 : skgfqsbi: media manager protocol error
  • ora-03249 : Uniform size for auto segment space managed tablespace should have atleast string blocks
  • ora-08187 : snapshot expression not allowed here
  • ora-39500 : failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
  • ora-01550 : cannot drop system tablespace
  • ora-36761 : (XSLANGDM01) Analytic workspace string already contains a dimension (%J) with the string property.
  • ora-09800 : Process sensitivity label retrieval failed.
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-10906 : Unable to extend segment after insert direct load
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-01095 : DML statement processed zero rows
  • ora-27190 : skgfrd: sbtread2 returned error
  • 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.