I am following the given link. https://oracle-base.com/articles/10g/oracle-data-pump-10g
I'm an Oracle newbie. Oracle 12c is the target version. I have a Development database running in a docker image and I'm logged in as
sys user to make sure that I can see everything. I'm using DataGrip as a client. I'm looking for the
DBMS_DATAPUMP package but I don't see it in the GUI and I've also tried
SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','package') order by OBJECT_NAME;, but I still don't see it. If it isn't installed, where do I download it from? I believe I've already figured out how to install it.
Our objective is as follows. We want to try creating a master schema in CI that is kept up to date on a weekly or monthly basis and then we want to copy that schema as our starting point for integration tests. Right now we are suffering through a painfully long flyway based migration process.