ERROR in dbms_datapump.add_file after introduce '%U'
Hello,
the OEM job:
declare
h1 NUMBER;
Dia varchar2(10);
begin
select to_char(sysdate,'YYYYMMDD') into Dia from dual;
--
h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'FULL', job_name => 'ExportFull' || Dia , version => 'COMPATIBLE');
dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.add_file(handle => h1, filename => 'ExportFull'||Dia||'.log', directory => 'DIR_EXPORT', filetype => 3);
dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
dbms_datapump.add_file(handle => h1, filename => 'ExportFull' || Dia || '.dmp', directory => 'DIR_EXPORT', filetype => 1);
dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
declare
h1 NUMBER;
Dia varchar2(10);
begin
select to_char(sysdate,'YYYYMMDD') into Dia from dual;
--
h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'FULL', job_name => 'ExportFull' || Dia , version => 'COMPATIBLE');
dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.add_file(handle => h1, filename => 'ExportFull'||Dia||'.log', directory => 'DIR_EXPORT', filetype => 3);
dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
dbms_datapump.add_file(handle => h1, filename => 'ExportFull' || Dia || '.dmp', directory => 'DIR_EXPORT', filetype => 1);
dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
0