Database Utilities (MOSC)

MOSC Banner

Why would one table import stall at the same spot on every attempt?

edited Apr 24, 2024 1:41AM in Database Utilities (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center