Hi,
I've read a lot about ORA-39112 errors when using impede, but I didn't find any article matching exactly my case.
So I'm using DBMS_DATAPUMP package (server is running 10.2.0.5.0) to copy a schema from one server to another and it almost works as intended.
The only error I get is a
ORA-39112: Dependent object type OBJECT_GRANT:"USER" skipped, base object type VIEW:"USER"."TRANSLATION_CHECK" creation failed
The wired part is that the view TRANSLATION_CHECK is imported (hence created) and its status is VALID. So why does he tells me the view creation has failed?.
I found an article (Doc ID 1297511.1) about grants not being made because the view is created by CREATE FORCE but the view could not be created without error, because an object it depends on is not valid or even not available. I guess this is not the case as the view exists AND its status is VALID.
I found another article (Doc ID 2029333.1) about grants not being made because the view is having object type columns. But the view TRANSLATION_CHECK has only VARCHAR2 columns (and one CHAR col).
So any idea what's causing this or how to track that down? Is there such thing as a verbose mode of DBMS_DATPUMP, where it tells a bit more what's going on under the hood.
Dirk