и опять....ежель кому интересно, кроме меня:
задал вопрос на формуах otn - получил ответ:
| Я |
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
test data:
create table some_tab (id varchar2(10), xml XMLType);
/
insert into some_tab values('short', XMLType('<foo></foo>'));
/
-- we use clob to pass more than 2000 symbols
declare
c clob := '<x> || lpad('</x>', 2700, 'a');
begin
insert into some_tab values('long', XMLType(c));
end;
/
then I export data with expdp...
and if I import dump into other schema on the same server - that's ok,
BUT if I import data into schema on other server - I have this error:
KUP-11007: conversion error loading table ......
ORA-26093: input data column size (2707) exceeds the maximum input size (2000)
KUP-11009: data for row: ....
|
| Toni Lazarin |
Bug 7209038
DATAPUMP NOT IMPORTING XMLTYPE OBJECTS. ORA-26093
Currently no workaround is available for this, although 11gR2 should have this fixed. |
Скажите, пожалуйста, а 11gR2 под win уже вышла или еще нет?