This content has been marked as final. Show 6 replies
select substr(sql_text,instr(sql_text,'INTO "'),30) table_name,
round((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes,
trunc(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_min
where sql_text like 'INSERT %INTO "%'
and command_type = 2
and open_versions > 0;
if you get 0 rows, the import is stop, you should stop it and try with data pump.
Also, you are using version 184.108.40.206, you must use 220.127.116.11, less bugs..
I got 0 rows as output of your query so I am going ahead with the data pump solution. Now the issue is the source and target db are at different versions -source is at 18.104.22.168 and target is at 22.214.171.124. So do I try to get it done using network_link, will that work? Are there some ways to tune the import session where the import is being done in different a server in a different country than the source server so a lots of network is involved?
You can use data pump in different databases and different versions:
just remember to user VERSION parameter when you run the expdp:
when the expdp finish just move the dumpfile to the server where the target database is and run the impdp.