Hi, I have huge table (size around 300gb) in source database and want to insert those records to target database table. I can not use expdp/imp due to space issue on both source and target server mountpoint. I even can not use network link from target to copy records from source because source database version is higher than target.
I was thinking to use like below
insert into targettable select * from sourcetable@dblinktosource;
but I am not sure how long this is going to take, I had started this insert six hours back with parallel 16 and its still doing select in remote database,
Please suggest any better way to do this