Wednesday 25 March 2009

11g : Errors using exp as it is de-supported

Got some errors running exp on an 11G cluster due to missing perms

Met*link stated that exp/imp are actually desupported in 11G in favour of data pump

Work around fix was to grant the following directly to the exp-orting user

GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO <user_name>;
GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO <user_name>;

Fini


0 comments: