I am doing an import during which i got this error .
IMP-00017: following statement failed with ORACLE error 4021:
"GRANT EXECUTE ON "VCP_PMC_PKG" TO "HERNANDEZO""
IMP-00003: ORACLE error 4021 encountered
ORA-04021: timeout occurred while waiting to lock object NCC.VCP_PMC_PKG.
SQL> SELECT * FROM v$access WHERE object = 'VCP_PMC_PKG';
SQL> select oracle_username, os_user_name,locked_mode,object_name,object_type
from v$locked_object a, dba_objects b
no rows selected.
how to get rid of this error?
Thanks in advance.
04-30-2007, 02:43 PM
somoene is trying to use it, stop all sessions before your import
04-30-2007, 05:11 PM
No users are connected to it as its not live (db) yet.So should i bounce the db and reimport once again.My parfile is
userid='/ as sysdba'
do i have to drop indexes and reimport it once again?
04-30-2007, 05:42 PM
Assuming the only error you got was the GRANT EXECUTE... one you do not have to re-import everything, specially 'cause it looks like a full exp/imp
Just import NCC schema fromuser/touser with ROWS=NO, IGNORE=YES options
By the way... somebody was using that package at the time you attempted to grant the privilege.