I am trying to load remote schema over dblink, using DBMS_DATAPUMP
In the source schema, I have created one view, which I want to materialize on the target side as a permanent table.
At, least, I have understand that over the option VIEWS_AS_TABLES I could do that.
S, on the source side I have :
create or replace view v_table1 as
select col1 , col2 from table1;
Then, in the PL/SQL code I am using the following:
DBMS_DATAPUMP.METADATA_FILTER (handle => v_handle,
name => 'VIEWS_AS_TABLES',
VALUE => 'SOURCESCHEMA.V_TABLE1:NEWTABLENAME');
but getting in the log file the error:
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD [ESTIMATE_PHASE]
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 12092
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_METADATA", line 7226
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 7213
ORA-06512: at "SYS.KUPW$WORKER", line 9203
when I omit this, or , when I put the name of the view that does not exists, then the pump job completes....with the error inside the log file that the mentioned view name can not be found..but the job completes.
I tried various syntax modifications, because, I am not able to find any on the net, but always the error.
Please can you advice me how to use rpoperly option VIEWS_AS_TABLES within DBMS_DATAPUMP, to get the view imported on the target side as a permanent table.