Hello
I’m getting one error while import the data using dbms data pump.
Source Database:
NLS_RDBMS_VERSION 23.0.0.0.0
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8ISO8859P1
Destination Database:
NLS_RDBMS_VERSION 23.0.0.0.0
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET AL32UTF8
Table Description:
Name Null? Type
---- -------- ---------
ID NUMBER
NAME NOT NULL CHAR(100)
Table Data:
ID NAME
---- ----------
1 char 1 : é
2 char 2 : é
3 char 3 : é
Data pump import :
declare
l_dp_handle number;
begin
l_dp_handle := dbms_datapump.open(
operation => 'IMPORT',
job_mode => 'TABLE',
remote_link => NULL,
job_name => 'impdp-01',
version => 'LATEST');
dbms_datapump.add_file(
handle => l_dp_handle,
filename => 'tab_part_A_%U.dmp',
directory => 'DPUMP_DIR');
dbms_datapump.add_file(
handle => l_dp_handle,
filename => 'impdp-01.log',
directory => 'DPUMP_DIR',
filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE);
dbms_datapump.set_parameter (l_dp_handle, 'TABLE_EXISTS_ACTION', 'TRUNCATE');
dbms_datapump.start_job(l_dp_handle);
dbms_datapump.detach(l_dp_handle);
end;
/
I’m exporting the table in source database and importing in destination database.
While importing I’m getting this error in data pump import log
Master table "SYS"."impdp-01" successfully loaded/unloaded
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
Warning: possible data loss in character set conversions
Starting "SYS"."impdp-01":
Processing object type TABLE_EXPORT/TABLE/TABLE
Table "ART"."CATEGORY" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
KUP-11007: conversion error loading table "ART"."CATEGORY"
ORA-12899: value too large for column NAME (actual: 101, maximum: 100)
KUP-11009: data for row: NAME : 0X'636861722031203A20E9202020202020202020202020202020'
KUP-11007: conversion error loading table "ART"."CATEGORY"
ORA-12899: value too large for column NAME (actual: 101, maximum: 100)
KUP-11009: data for row: NAME : 0X'636861722032203A20E9202020202020202020202020202020'
KUP-11007: conversion error loading table "ART"."CATEGORY"
ORA-12899: value too large for column NAME (actual: 101, maximum: 100)
KUP-11009: data for row: NAME : 0X'636861722033203A20E9202020202020202020202020202020'
. . imported "ART"."CATEGORY" 5.804 KB 0 out of 3 rows
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYS"."impdp-01" completed with 9 error(s) at Thu Nov 10 09:34:28 2022 elapsed 0 00:00:10And there is no data present after import.
Can anybody please help to understand this error and fix it ?
Thanks
T