Create Table As Select over DB Link
Hi Guys!
Can somebody tell me whether doing the following would be efficient? Create a table on database B as select from database A over a DB link, using parallel hint. Intention is to migrate data from database A to database B where both DBs are Oracle 10g R2.
If there was another option of exporting data with Data Pump, which method would be most suitable?
Many thanks in advance!!!