i would like to use dbms_datapump with the option "VIEWS_AS_TABLES"
Database Version Version 19.7.0.0.0
This Version Works fine:
declare
l_dp_handle number;
begin
-- Open a table export job.
l_dp_handle := dbms_datapump.open(
operation => 'EXPORT',
job_mode => 'TABLE',
remote_link => NULL,
job_name => 'TESTUSER1_EMP_EXPORT',
version => '12');
-- Specify the dump file name and directory object name.
dbms_datapump.add_file(
handle => l_dp_handle,
filename => 'TESTUSER1_EMP.dmp',
directory => 'FILE_EXP');
-- Specify the log file name and directory object name.
dbms_datapump.add_file(
handle => l_dp_handle,
filename => 'expdpTESTUSER1_EMP.log',
directory => 'FILE_EXP',
filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE);
-- Specify the table to be exported, filtering the schema and table.
0