We have recently had a customer upgrade to Oracle 19c and thus we have installed the same - Enterprise 19c.
We took an EXPDP of the customer's DB.
This is a very normal practice for us in many versions of Oracle up to 12cR2.
In our new Oracle 19c I created the database, created the datafiles and users etc. just as I have always done. It is not a Container Database - No Grid stuff at all...just standalone.
impdp 'xxxxxxxxx/yyyyyyyyy@DB19c' TABLE_EXISTS_ACTION=replace dumpfile=expdp_taad0002eq_taawfcdv_TKCSOWNER_20200420_2030_%U.dmp directory=data_pump_dir logfile=DB-19c-imp.log parallel=4
Everything went as normal and I could see the tables populating.etc.
Then it stopped at this point in the DB-19c.log.
"Processing object type SCHEMA_EXPORT/VIEW/VIEW"
I say stopped but the 4 core DB server still remains running 20-40% CPU as if the datapump is ongoing. But we have left it for days and no change.
We have attempted as second import and it stops at the same place in the log again and CPU continues to be used - A week and half has gone by.
What could be stopping the impdp completing?
We are not specifically DBA's but have never had this kind of issue previously and we restore our customers databases for support issues all the time.
We are in the ORA_DBA and Administrator Groups on the DB server.