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


      Hi there


      Just recently I have upgraded my production database from Oracle to 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 .