Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
Performance & Availability
This discussion is archived
on Apr 30, 2012 6:12 PM by 275191
Copy XML data to remote instance
Apr 27, 2012 11:30 PM
As streams-based replication is not available for structured storage what are alternatives to copy XML data to remote instance?
Will this work? Limitations?
insert into MY_XML_TABLE@remote_instance
select * from MY_XML_TABLE;
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Copy XML data to remote instance
Apr 30, 2012 6:12 PM
in response to
Figured it works other direction, into local from remote as
insert into MY_XML_TABLE
select * from MY_XML_TABLE@remote_instance
Not sure if there are limitations in this casse