Hi,
oracle 11.2.0.2
I am getting below error while trying to import through db link.
declare
v_xHandle number;
v_DB_Source_Name varchar2(50);
v_DB_Dest_Name varchar2(50);
2 3 4 5 v_Schema_Import varchar2(50);
6 v_job_name varchar2(100);
7 begin
8 v_DB_Source_Name := 'X';
9
10
11
12
13
14
15
16
17
18 v_job_name :='v_job'
19
20
21 v_xHandle := dbms_datapump.open(
22 operation => 'IMPORT',
23 job_mode => 'SCHEMA',
24 remote_link => 'Y',
25 job_name => v_job_name
26 );
27
28 dbms_output.put_line(v_job_name);
29 dbms_datapump.start_job(handle => v_xHandle);
30
31 dbms_output.put_line('v_xHandle :'||v_xHandle);
32 -- Successful DataPump Export job completion, so detach from the job
33 dbms_output.put_line('Job ' || v_job_name ||' has completed');
34 dbms_datapump.detach(v_xHandle);
35 exception
36 when others then
37 dbms_datapump.stop_job(v_xHandle);
38 end;
39
declare
*
ERROR at line 1:
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 1137
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5658
ORA-06512: at line 37
select * from dual@Y is successful.