Thursday, July 16, 2009

SYS.DBMS_EXPORT_EXTENSION

Imp Par File Err

grants=n
buffer=1000000
log=vms4_qlac.log
userid=abc/pass
file=qlac.dmp
FROMUSER=vms4_qlac
FEEDBACK=1000


PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declared


Fix :

GRANT EXECUTE ON DBMS_EXPORT_EXTENSION to
or
GRANT EXECUTE ON DBMS_EXPORT_EXTENSION to PUBLIC

No comments: