ADADMIN ORA-01653: unable to extend table APPLSYS.AD_SNAPSHOT_FILES by 16 in tablespace APPS_TS_TX_DATA adusnapMaintainSnapshot (Doc ID 1597193.1)

Last updated on NOVEMBER 09, 2016

Applies to:

Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When running adadmin as below:

adadmin > 2. Maintain Applications Files menu > 4. Maintain snapshot information >2. update current view snapshot > 1. update complete APPL_TOP

The following error results:

32% Complete. Done updating 268001 rows[Wed Oct 23 2013 09:08:17].
32% Complete. Done updating 270001 rows[Wed Oct 23 2013 09:08:18].
32% Complete. Done updating 272001 rows[Wed Oct 23 2013 09:08:19].
AD Administration error:
adusnapUpdateGlobalView(): Error while executing statement

AD Administration error:
ORA-01653: unable to extend table APPLSYS.AD_SNAPSHOT_FILES by 16 in tablespace APPS_TS_TX_DATA
ORA-06512: at "APPS.AD_FILE_UTIL", line 2535
ORA-06512: at line 3


AD Administration error:
adusnapStoreInDB(): Error calling adusnapUpdateGlobalView()

Failed to store APPL_TOP Snapshot to tables
adusnapMaintainSnapshot() : Error calling adusnapUpdateCurrentView2()
Error calling adusnapPartialCurVw()
Error calling adusnapMaintainSnapshot



Backing up restart files, if any......Done.

You should check the file
/u02/prod/apps/apps_st/appl/admin/PROD/log/adadmin.log

for errors.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms