Error 1273900: Database Studio

To set a bookmark to this detailed view right-click here

Message Data

Reported

Settlement

Delivered

 
79.10.04 Delivered 79.11.00  

Created

Processed

Completed

Affected OS

2020-01-24 2020-01-24 2020-02-03 All

Message Texts

Description Solution Patch Information Links

Description

Top
Recreating a bad index as SYSDBA fails in databases of version > 7.9.09.10 with the following error: Error Executing 'drop index "<index name>" on "<schema name>"."<table name>"' [-4004] (at 37): Unknown table name or unknown schema
 

Solution

Top
With version 7.9.09.10 a new SQL command was introduced that must be used as SYSDBA to recreate bad indexes of other users tables
 

Patch Information

Top
Appearance: Recreating a bad index as SYSDBA failed in databases of version > 7.9.09.10 with the following error: Error Executing 'drop index "<index name>" on "<schema name>"."<table name>"' [-4004] (at 37): Unknown table name or unknown schema Preconditions and circumstances: None Workaround: None
 

Links

Top

Id

Type

Description

Settlement

Planned Delivery

   1273901 Error Recreating a bad index as SYSDBA fails in databases of version > 7.9.09.10 with... 79.10.04 4   
 
  Close Window     Help