Four Stars

Oracle to Oracle table Data Transfer

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.

1 REPLY
Moderator

Re: Oracle to Oracle table Data Transfer

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.