My Oracle Support Banner

EBS Gather Schema Statistics throws ORA-00959: tablespace 'OKCD' does not exist (Doc ID 2584512.1)

Last updated on SEPTEMBER 04, 2019

Applies to:

Oracle E-Business Suite Performance - Version 11.5.10.0 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

I'am trying gather statistics for OKC schema in a EBS database, and the error below appears.
In my others schemas the execution ends without any error
why does gather_schema request a certain tablespace for this schema?


SQL> EXEC fnd_stats.GATHER_SCHEMA_STATS( schemaname=> 'OKC', estimate_percent=> dbms_stats.auto_sample_size, degree=>10, options => 'GATHER AUTO');
*
ERROR at line 1:
ORA-00959: tablespace 'OKCD' does not exist
ORA-06512: at "APPS.FND_STATS", line 2025
ORA-06512: at "APPS.FND_STATS", line 1675
ORA-06512: at line 1

Tried to recreate this table in another tablespace below:

SQL>  DROP TABLE OKC.OKC_TIMEVALUES_MAL purge;
DROP TABLE OKC.OKC_TIMEVALUES_MAL purge
               *
ERROR at line 1:
ORA-00959: tablespace 'OKCD' does not exist


I created the tablespace OKCD for test propose

CREATE TABLESPACE OKCD DATAFILE '+DATA' size 100M;

After that:

SQL> DROP TABLE OKC.OKC_TIMEVALUES_MAL purge;
DROP TABLE OKC.OKC_TIMEVALUES_MAL purge
              *
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktadrprc-1], [], [], [], [], [],
[], [], [], [], [], []


The ORA-600 [ktadrprc-1] (Doc ID 309315.1) send me too the Doc ID 136697.1
In the second Doc I downloaded the script hcheck.sql and ran to check Data Dictionary problems
The complete output is attached (DES_ora_26893_HCHECK.trc)

HCKE-0019: Orphaned TAB$ (no SEG$) (Doc ID 1360889.1)
ORPHAN TAB$: OBJ#=3717271 DOBJ#=3717271 TS=199 RFILE/BLOCK=0/0
TABLE=OKC.OKC_TIMEVALUES_MAL BOBJ#=        <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< same table with original problem

.- OrphanedTablePartition      ... 1102000400 <=  *All Rel* 08/26 11:31:06 PASS
.- OrphanedTableSubPartition   ... 1102000400 <=  *All Rel* 08/26 11:31:06 PASS
.- MissingPartCol              ... 1102000400 <=  *All Rel* 08/26 11:31:06 PASS
.- OrphanedSeg$                ... 1102000400 <=  *All Rel* 08/26 11:31:07 FAIL


ADRCI package attached 

OKC is custom schema.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.