ImpDp : ORA-00904: "USERNAME" and anonymous block
My problem :
The import of function is failed. What is the problem ?
The command :
impdp DATAPUMP/****@GPAO TRACE=1FF0300 DIRECTORY=datapump schemas=GCOM INCLUDE=FUNCTION DUMPFILE=REGIS.DUMP LOGFILE=REGIS.log TABLE_EXISTS_ACTION=replace
A part of trace file :
KUPM: 16:00:44.229: Traitement du type d'objet SCHEMA_EXPORT/FUNCTION/FUNCTION
KUPC: 16:00:44.229: Before ENQ: Sending Type: 2023 ID: DG,KUPC$S_1_20110927160040,MCP, ,3,Y
KUPM: 16:00:44.229: *******OUT DISPATCH , request type=3031 response type =2041
KUPC: 16:00:44.229: Before Listen: consumer = MCP from queue = SYS.KUPC$C_1_20110927160040
KUPC: 16:00:44.354: Before Dequeue: msg type is: 1
KUPC: 16:00:44.354: Dequeued msg type: 3032 ID: DG,KUPC$C_1_20110927160040,KUPC$A_1_20110927160043,MCP,8,Y
KUPM: 16:00:44.354: *******IN DISPATCH at 57644, request type=3032
The import of function is failed. What is the problem ?
The command :
impdp DATAPUMP/****@GPAO TRACE=1FF0300 DIRECTORY=datapump schemas=GCOM INCLUDE=FUNCTION DUMPFILE=REGIS.DUMP LOGFILE=REGIS.log TABLE_EXISTS_ACTION=replace
A part of trace file :
KUPM: 16:00:44.229: Traitement du type d'objet SCHEMA_EXPORT/FUNCTION/FUNCTION
KUPC: 16:00:44.229: Before ENQ: Sending Type: 2023 ID: DG,KUPC$S_1_20110927160040,MCP, ,3,Y
KUPM: 16:00:44.229: *******OUT DISPATCH , request type=3031 response type =2041
KUPC: 16:00:44.229: Before Listen: consumer = MCP from queue = SYS.KUPC$C_1_20110927160040
KUPC: 16:00:44.354: Before Dequeue: msg type is: 1
KUPC: 16:00:44.354: Dequeued msg type: 3032 ID: DG,KUPC$C_1_20110927160040,KUPC$A_1_20110927160043,MCP,8,Y
KUPM: 16:00:44.354: *******IN DISPATCH at 57644, request type=3032
0