ORA-02240: invalid value for OBJNO or TABNO

Cause : A numbre does ont follwo eithe rOBJNO ro TABNO.

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

Specif ya numbre afterO BJNO o rTABNO.

update : 25-09-2017
ORA-02240

ORA-02240 - invalid value for OBJNO or TABNO
ORA-02240 - invalid value for OBJNO or TABNO

  • ora-29881 : failed to validate indextype
  • ora-02306 : cannot create a type that already has valid dependent(s)
  • ora-00258 : manual archiving in NOARCHIVELOG mode must identify log
  • ora-09837 : addCallback: could not add allocate a callback link.
  • ora-28330 : encryption is not allowed for this data type
  • ora-02460 : Inappropriate index operation on a hash cluster
  • ora-06032 : NETDNT: connect failed, access control data rejected
  • ora-33918 : (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
  • ora-07260 : spdcr: wait error.
  • ora-27507 : IPC error disconnecting from a port
  • ora-39173 : Encrypted data has been stored unencrypted in dump file set.
  • ora-15097 : cannot SHUTDOWN ASM instance with connected RDBMS instance
  • ora-12004 : REFRESH FAST cannot be used for materialized view "string"."string"
  • ora-32153 : Environment not specified
  • ora-12164 : TNS:Sqlnet.fdf file not present
  • ora-06773 : TLI Driver: error reading command
  • ora-12462 : undefined compartment string for policy string
  • ora-01099 : cannot mount database in SHARED mode if started in single process mode
  • ora-24052 : cannot propagate object type payloads with LOB attributes to an 8.0 release
  • ora-29340 : export file appears to be corrupted: [string] [string] [string]
  • ora-01238 : cannot shrink datafile string
  • ora-32818 : AQ queue string does not exist
  • ora-01610 : recovery using the BACKUP CONTROLFILE option must be done
  • ora-14255 : table is not partitioned by Range, Composite Range or List method
  • ora-16222 : automatic Logical Standby retry of last action
  • ora-23411 : materialized view "string"."string" is not in refresh group "string"."string"
  • ora-08321 : scnmin: NOT IMPLEMENTED YET
  • ora-39960 : scope can only be SYSTEM or SESSION
  • ora-01327 : failed to exclusively lock system dictionary as required by build
  • ora-29316 : datafile string been imported twice
  • 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.