I have to move some data between schemas and the table contains an
ANYDATA column with varchar2 data. When I extract insert statements the
value is null, so I assume I have to translate the data to varchar 2 and
back. Anyone have an example how to do this?
insert into schema2.table2 (column list)
select from schema1.table1;
If they are in separate databases, I would try the SQL Plus COPY command.
Sorry, should have mentioned that the schemas are in different databases and
also I’m not allowed to create a dblink between them (dev and prod)
On 6/24/2011 11:29 AM, John Dorlon wrote:
insert into schema2.table2 (column list)
select from schema1.table1;
If they are in separate databases, I would try the SQL Plus COPY command.
Next time I’ll try the sql plus copy command…Thanks!
On 6/24/2011 11:29 AM, John Dorlon wrote:
insert into schema2.table2 (column list)
select from schema1.table1;
If they are in separate databases, I would try the SQL Plus COPY command.
Thanks, I used the functions in here…very helpful.
On 6/24/2011 11:25 AM, Jeff Smith wrote:
This may help
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/t_anydat.htm#i
1001287