The import operation needs to be able to create any object in any schema in order to succeed. Right?
Remember this truism for Oracle. Privileges acquired via a ROLE do NOT apply within PL/SQL procedure.
I tried to give all privileges to my user
GRANT ALL PRIVILEGES to PUMPUSER;
also, I tried with the user which has the same name like one from used dblink
but I am still getting the same error....
when I tried the same from the PDB attached directly on CDB root, and which is not opened as RESTRICTED, it works.
So, the problem seems to be in one of those 2 mentioned.
That my PDB belongs to the app. container, or that its RESTRICTED attribute is YES.
At the moment, all PDBs that I create are RESTRICTED, even after the db server is restarted.
I am going to try to find why