Oracle to Oracle table Data Transfer

[Anonymous]

Hi All,

I want to Transfer the Data from Source Oracle to Destination Oracle.

In data one Column have XMLTYPE, while transfer the data am getting below error.

Error:

[statistics] connecting to socket on port 4052
[statistics] connected
ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'.

Design: 

tInputOracle --> tOutputOracle.

Kindly help me. I want to tansfer 2 Million data from one schema to another schema.

[Anonymous]

Hello,

What does your input query look like? Are you using EXTRACTVALUE() EXTRACT() in it?

Best regards

Sabrina