7 Replies Latest reply on Mar 3, 2014 1:53 AM by Hemant K Chitale

    ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout

    Rabi786

      Hi there

       

      Just recently I have upgraded my production database from Oracle 10.2.0.3 to 11.2.0.3. Most of the time I am getting the following error in my alert log file

       

      OS : IBM AIX 6.1

       

      Sun Mar 02 14:52:44 2014

      ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP

      Errors in file /orafs/app/oracle/diag/rdbms/pblprod/pblprod/trace/pblprod_j001_16122158.trc:

      ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_3569"

      ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

      ORA-06512: at "SYS.DBMS_ADVISOR", line 201

      ORA-06512: at "SYS.DBMS_SPACE", line 2276

      ORA-06512: at "SYS.DBMS_SPACE", line 2538

       

      Could you please give any suggestion to solve it .

       

      Regards

       

      Rabi