Erro ao fazer a carga do campo tipo BLOB – ORA-22275

[Afonso RodriguesParticipante]

Olá @rman.

Infelizmente, este não é o meu erro.

Fiz alguns testes e quando eu crio as tabelas diretamente, sem opcionais, apenas o
create table na origem e no destino dá certo a carga.

Creio que o erro que estou tendo, é relacionado à forma com que a tabela foi criada.

Tabela na origem:

CREATE TABLE "USER"."TABELA_TESTE"
(
"IDC_REGISTRO" NUMBER(10,0) NOT NULL ENABLE,
"IDC_PECA" NUMBER(12,0) NOT NULL ENABLE,
"IDC_ANALOGICA" NUMBER(2,0) NOT NULL ENABLE,
"COD_ORDEM_PRODUCAO" VARCHAR2(12 BYTE) NOT NULL ENABLE,
"NUM_SECAO_EIXO_X" BLOB,
"NUM_SECAO_EIXO_Y" BLOB,
"DTH_CRIACAO_REG" DATE,
"TESTE" VARCHAR2(20 BYTE),
CONSTRAINT "TABELA_TESTE_PK" PRIMARY KEY ("IDC_PECA", "IDC_ANALOGICA") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE
)
SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "USERS" LOB
(
"NUM_SECAO_EIXO_X"
)
STORE AS BASICFILE
(
TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
)
LOB
(
"NUM_SECAO_EIXO_Y"
)
STORE AS BASICFILE
(
TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
) ;
CREATE UNIQUE INDEX "USER"."SYS_IL0000205504C00006$$" ON "USER"."TABELA_TESTE"
(
PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" PARALLEL (DEGREE 0 INSTANCES 0) ;
CREATE UNIQUE INDEX "USER"."SYS_IL0000205504C00005$$" ON "USER"."TABELA_TESTE" ( PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" PARALLEL (DEGREE 0 INSTANCES 0) ;
CREATE UNIQUE INDEX "USER"."TABELA_TESTE_PK" ON "USER"."TABELA_TESTE" ("IDC_PECA", "IDC_ANALOGICA") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ;

Tabela no destino

CREATE TABLE "USER"."TABELA_TESTE"
(
"IDC_REGISTRO" NUMBER(10,0) NOT NULL ENABLE,
"IDC_PECA" NUMBER(12,0) NOT NULL ENABLE,
"IDC_ANALOGICA" NUMBER(2,0) NOT NULL ENABLE,
"COD_ORDEM_PRODUCAO" VARCHAR2(36 BYTE) NOT NULL ENABLE,
"NUM_SECAO_EIXO_X" BLOB,
"NUM_SECAO_EIXO_Y" BLOB,
"DTH_CRIACAO_REG" DATE,
"TESTE" VARCHAR2(20 BYTE),
CONSTRAINT "TABELA_TESTE_PK" PRIMARY KEY ("IDC_PECA", "IDC_ANALOGICA") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USER_TBS" ENABLE
)
SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "USER_TBS" LOB
(
"NUM_SECAO_EIXO_X"
)
STORE AS BASICFILE
(
TABLESPACE "USER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
)
LOB
(
"NUM_SECAO_EIXO_Y"
)
STORE AS BASICFILE
(
TABLESPACE "USER_TBS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
) ;
CREATE UNIQUE INDEX "USER"."TABELA_TESTE_PK" ON "USER"."TABELA_TESTE"
(
"IDC_PECA", "IDC_ANALOGICA"
)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE
(
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
)
TABLESPACE "USER_TBS" ;
CREATE UNIQUE INDEX "USER"."SYS_IL0014893528C00005$$" ON "USER"."TABELA_TESTE"
(
PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USER_TBS" PARALLEL (DEGREE 0 INSTANCES 0) ;
CREATE UNIQUE INDEX "USER"."SYS_IL0014893528C00006$$" ON "USER"."TABELA_TESTE" ( PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USER_TBS" PARALLEL (DEGREE 0 INSTANCES 0) ;

Obrigado