Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

How to fix - missing object_name: 0

Asked by Andrea Bailey Sep 29, 2022 624 views 1 answer
Share

About this question

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.

Your answer

1 Answer

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.