Skip to main content
Question

Is there a way to copy several tables from an oracle database to another oracle database?

  • February 23, 2017
  • 4 replies
  • 159 views

arthy
Contributor
Forum|alt.badge.img+8
  • Contributor

Hello,

Is there a way to copy several tables from an oracle database to another oracle database?

I don't want to have to list all the table separately in a workspace given that I have to deal with approximately one hundred tables

Thanks

4 replies

david_r
Evangelist
  • February 23, 2017

itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • February 23, 2017

Yep that the way to go, no hassle and straight up input becomes output.


runneals
Contributor
Forum|alt.badge.img+19
  • Contributor
  • December 4, 2019

This is one of our ETL jobs in FME. It takes 50 minutes to run. Is there a better way to move data from one database to another (like sql script)? This is currently from oracle to oracle, but eventually am moving the output database to SQL server.

Worth noting is that the reprojector and attribute manager isn't needed.

 


david_r
Evangelist
  • December 4, 2019
runneals wrote:

This is one of our ETL jobs in FME. It takes 50 minutes to run. Is there a better way to move data from one database to another (like sql script)? This is currently from oracle to oracle, but eventually am moving the output database to SQL server.

Worth noting is that the reprojector and attribute manager isn't needed.

 

If you need it to execute much faster, you should look into making a direct connection between the two Oracle instances (e.g. use Database Link) and use regular SQL statements to copy the table contents. You can of course use FME for this. This method is usually much, much faster than loading the data into FME before writing it back again.

From Oracle to SQL Server it gets a bit more tricky, but it seems doable, see e.g. https://www.sqlshack.com/link-sql-server-oracle-database/

You should also consider posting this as a separate question to get more visibility.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings