Oracle to Oracle table Data Transfer

Anonymous — Sat, 04 Nov 2017 06:27:31 GMT

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.

Re: Oracle to Oracle table Data Transfer

Anonymous — Tue, 07 Nov 2017 07:17:19 GMT

Hello,

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

Best regards

Sabrina