developer-support
developer-support copied to clipboard
IMPDP.sql - additional information
Hi, this is related to the IMPDP procedures listed here: https://github.com/Esri/developer-support/blob/master/arcsde-sql/oracle/data-pump/IMPDP.sql
I experience the behavior described here: https://support.esri.com/en/technical-article/000012391
For me the solution was to make an additional:
GRANT INHERIT ANY PRIVILEGES TO "SDE";
as well as
grant EXECUTE ON dbms_crypto to public;
I hope that helps someone. Thanks you for the script, saved a lot of work!