How to fix - missing object_name: 0

201    Asked by AndreaBailey in SQL Server , Asked on Sep 29, 2022

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 a 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.


Answered by Andrew Jenkins

Your Answer

Interviews

Parent Categories