Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> IMPDP hangs when moving a table with a blob column

IMPDP hangs when moving a table with a blob column

From: rjlolli <rjlolli_at_sbcglobal.net>
Date: 23 Jan 2006 11:06:04 -0800
Message-ID: <1138043164.473182.126270@g43g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US