اخواني قمت بعمل اسكبروت لجدولين من السكيمه سكوت فظهرت لي هذه النتيجيه

About to export specified tables via Conventional Path ...
. . exporting table EMP 14 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifier
. . exporting table DEPT 4 rows exported
EXP-00056: ORACLE error 904 encountered
ORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifier
Export terminated successfully with warnings.

ما معنى انه تم عمل الاكسبورت بنجاخ ولمن مع تحذير

وشكرا

Salamo alikom
Normally when you made an export if any error comes out it tries the next table to export till it finish and it will gives you this message "Export terminated successfully with warnings"
for SYS package it seems that it is not valid and i think it needs recompile. there was one script file in this location $ORACL_HOME\RDBMS\Admin\Cat*.sql i'm not remembering the file name but it is used to recompile all the sys schema to resolve any compilation errors.

Regards;

Conn as sysdba

then run the following script

SET SERVEROUTPUT ON SIZE 1000000
BEGIN FOR cur_rec IN (SELECT owner,
                        object_name,
                        object_type,
                        DECODE(object_type, 'PACKAGE', 1,
                                            'PACKAGE BODY', 2, 2) AS recompile_order
                 FROM dba_objects WHERE object_type IN ('PACKAGE', 'PACKAGE BODY') AND status != 'VALID'
                 ORDER BY 4)
 LOOP
   BEGIN IF cur_rec.object_type = 'PACKAGE' THEN
       EXECUTE IMMEDIATE 'ALTER ' || cur_rec.object_type || 
           ' "' || cur_rec.owner || '"."' || cur_rec.object_name || '" COMPILE';
     ElSE
       EXECUTE IMMEDIATE 'ALTER PACKAGE "' || cur_rec.owner || 
           '"."' || cur_rec.object_name || '" COMPILE BODY';
     END IF;
   EXCEPTION
     WHEN OTHERS THEN
       DBMS_OUTPUT.put_line(cur_rec.object_type || ' : ' || cur_rec.owner || 
                            ' : ' || cur_rec.object_name);
   END;
 END LOOP;
END;
/

Or you can use the folwoing SYS.Backage if it is valid in SYS Schema .
it will recompile all procedures, functions, packages, and triggers in the specified schema

EXEC DBMS_UTILITY.compile_schema(schema => 'SYS');

تحياتى