Skip to main content

Queries May Fail Against VDBs Containing Datafiles With Non-Zero Final Blocks (TB009)

Alert Type

Data Availability


If the last block of a datafile on a source database contains data, a query against a VDB provisioned from that source may fail with an ORA-08103 error due to missing data.

Contributing Factors

This issue occurs in the following Delphix Releases:

  • Delphix Engine
  • Delphix Engine

This issue may occur on VDBs provisioned from a source which has had data written to the last block of a datafile after the initial load was completed.


ORA-08103 errors while running queries on VDBs.  


ERROR at line 1: 
ORA-08103: object no longer exists 
ORA-06512: at "SYS.DBMS_STATS", line 18408 
ORA-06512: at "SYS.DBMS_STATS", line 18429 
ORA-06512: at line 1 


The Delphix Engine should be upgraded to the latest version of Delphix Engine 3.1 or later releases. Contact Delphix Support to arrange an upgrade.


The issue is addressed in Delphix Engine and later releases.


  • Was this article helpful?