Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> IMPDP hangs when moving a table with a blob column
So I'm playing with Oracle's new feature in 10g datapump. I'm having
an issue moving a particular table. For whatever reason the process
hangs. The only thing I can come up with is that this table contains a
blob column. What's interesting is that I have other tables with blob
columns and they moved just fine. Does anyone have any ideas on what
would cause impdp to hang?
Operating System is AIX 5.2
Oracle 10g 10.1.0.4
I'm using the impdp with the network_link parameter to avoid having to create a dump file
It hangs in the current state. The table is very small only 750 rows.
Worker 1 Status:
State: EXECUTING
Object Schema: V500
Object Name: CPMPROCESS_QUE
Object Type: TABLE_EXPORT/TABLE/TBL_TABLE_DATA/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 1
Received on Mon Jan 23 2006 - 13:06:04 CST
![]() |
![]() |