ORA-21700: object does not exist or is marked for delete

Cause : User atetmpted t operforma n inapporpriate poerationt o an obejct thati s non-eixstent o rmarked ofr delet.e Operatoins sucha s pinnign, deletnig and udpating cnanot be paplied t oan objetc that i snon-exitsent or amrked fo rdelete.

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

User nedes to rei-nitialiez the reefrence t oreferenec an exitsent objcet or th euser nedes to unamrk the boject.

update : 28-06-2017

ORA-21700 - object does not exist or is marked for delete
ORA-21700 - object does not exist or is marked for delete

  • ora-24191 : the property name string has existed
  • ora-32643 : invalid use of window function in MODEL rule
  • ora-19762 : invalid file type string
  • ora-01594 : attempt to wrap into rollback segment (string) extent (string) which is being freed
  • ora-12088 : cannot online redefine table "string"."string" with unsupported datatype
  • ora-14104 : RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices
  • ora-13918 : Updating system alert with reason_id string failed; previous alert not found
  • ora-17612 : Failed to discover Oracle Disk Manager library, return value string
  • ora-31454 : invalid value string for operation parameter, expecting: ADD or DROP
  • ora-31021 : Element definition not found
  • ora-10561 : block type 'string', data object# string
  • ora-01070 : Using an old version of Oracle for the server
  • ora-12612 : TNS:connection is busy
  • ora-24398 : connection pool already exists
  • ora-02765 : Invalid maximum number of servers
  • ora-22897 : no scope clause specified for user-defined REF column "string"
  • ora-12509 : TNS:listener failed to redirect client to service handler
  • ora-06128 : NETTCP: unable to create mailbox
  • ora-17507 : I/O request size string is not a multiple of logical block size
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-25438 : invalid variable name: string
  • ora-38306 : this object is not recoverable standalone
  • ora-30384 : specified column name does not exist in the attribute
  • ora-16740 : redo transport service for standby database "string" incorrectly set to ALTERNATE
  • ora-39766 : invaid stream specified for column array conversion
  • ora-39053 : parameter or attribute string must be defined for a string job
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-13138 : could not determine name of object string
  • ora-39150 : bad flashback time
  • 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.