Why would one table import stall at the same spot on every attempt?
I'm importing (impdp) table data (append) for one table and it stalls at "Completed Bytes: 25,000,320". I killed that job after a day and ran it again and it stalled at the same number of bytes.
I run the "top" command and that process is using 95-98% of the %CPU, but it never gets anywhere. I can do this for 50+ other tables and they run just fine.
Should I be checking some memory or rollback space somewhere? Any other things to check?
19c db on Linux 7
The tablespace is autoextensible and is seems far from the maxbytes.
BYTES MAXBYTES AUT 2.1998E+11 3.5184E+13 YES