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 : 18-08-2017

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

  • ora-07707 : error in archive text: need tape label name
  • ora-39180 : unable to encrypt ENCRYPTION_PASSWORD
  • ora-25321 : enqueue failed, user property specified but queue string.string is not an 8.1 style queue
  • ora-31693 : Table data object string failed to load/unload and is being skipped due to error: string
  • ora-30511 : invalid DDL operation in system triggers
  • ora-01622 : thread number must be specified - default not specific
  • ora-08444 : syntax error in JUSTIFIED clause in mask options
  • ora-16659 : failover operation in progress
  • ora-13295 : geometry objects are in different coordinate systems
  • ora-32733 : Error occurred when executing Parallel Oradebug
  • ora-28180 : multiple authentication methods provided by proxy
  • ora-32817 : message system link string is not configured with a log queue for string
  • ora-00323 : Current log of thread string not useable and all others need archiving
  • ora-02035 : illegal bundled operation combination
  • ora-01124 : cannot recover data file string - file is in use or recovery
  • ora-36164 : (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
  • ora-23293 : Cannot rename a column which is part of a join index
  • ora-13638 : The user interrupted the current operation.
  • ora-16171 : RECOVER...FINISH not allowed due to gap for thr string, seq string-string
  • ora-13195 : failed to generate maximum tile value
  • ora-09923 : Can't spawn process - user log directory not created properly
  • ora-34260 : (MXDCL25) You cannot use number to dimension a string because it is, or involves, a dimension composite. Use the composite's bases instead.
  • ora-01302 : dictionary build options missing or incorrect
  • ora-15092 : I/O request size string is not a multiple of logical block size string
  • ora-24012 : cannot drop QUEUE_TABLE, some queues in string have not been dropped
  • ora-13119 : invalid edge_id [string]
  • ora-23426 : deferred RPC queue has entries for string
  • ora-06316 : IPA: Invalid database SID
  • ora-16035 : missing required keyword string
  • ora-02064 : distributed operation not supported
  • 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.