Oracle Database Discussions

We are trying to import a dmp file to Oracle 10.2.0.1 database. This is a full import and ignore=y has been given. We found the following error for one particular user
---------
ORA-06550: line 2, column 5:
PLS-00302: component 'DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
-----------

We observed that this is being executed when connected as a user FIDILEO, and on a standalone sql session too, we are getting the same error when executing the package

----
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('XXXXXX','IBMPC/WIN_NT-8.1.0');
END;
/
----

After much research on web, I have now done a GRANT command after logged in as SYS user, as
GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO FIDILEO;
GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO PUBLIC;

Still, we cannot execute this procedure when logged in as FIDILEO and continues to give the same error message. However, new users and other users are able to execute the PLSQL Block. I have verified that the package and it's body is VALID.

Basic overlook of the privileges shows that all seems right, still not able to execute this PLSQL block. This issue is happening for 3 packages
1. SYS.DBMS_DEFER_IMPORT_INTERNAL
2. SYS.DBMS_EXPORT_EXTENSION
3. SYS.DBMS_LOGREP_IMP

These issues were not in 11g import. Only in 10g. Can anyone help?

Message was edited by:
user636365