ora-04021 during import

[nisha]

Hi Guys,
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';

SID OWNER
---------- ----------------------------------------------------------------
OBJECT
--------------------------------------------------------------------------------
TYPE
------------------------
174 NCC
VCP_PMC_PKG
PACKAGE

SQL> select oracle_username, os_user_name,locked_mode,object_name,object_type
from v$locked_object a, dba_objects b
where a.object_id=b.object_id;
2 3
no rows selected.

how to get rid of this error?

Thanks in advance.

[davey23uk]

somoene is trying to use it, stop all sessions before your import

[nisha]

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'
buffer=500000000
full=y
ignore=y
rows=n
indexes=y
constraints=y
grants=y
log=imp_VCP01I2.log
statistics=none
commit=y
do i have to drop indexes and reimport it once again?

[PAVB]

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.

[nisha]

Thanks