Clover newbie with what should be a simple question. I need to copy all tables from one remote Oracle db schema to another remote Oracle database. It is approximately 300 tables. How do I do this without having to create the metadata specifically for each table? Currently, for half of the tables I am calling a BASH script to do it using the SQLPlus copy command. However, the other tables have either CLOB or BLOB datatypes and can’t be copied using the COPY command. So, how do I copy a group of tables from one Oracle database to another in CLOVER without manually creating the metatdata for each table? Thanks.
Hi,
Probably the most appropriate way is to use the Oracle Data Pump utility. It is able to export/import all Oracle datatypes (metadata) and the content of the tables itself. You can use the SystemExecute (or ExecuteScript) component to execute the Data Pump directly from CloverETL graph (or jobflow). Below you can find some useful links to our and Oracle documentation.
http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/sysexecute.html
http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/executescript.html
https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm
Hope this helps.