I need to export thousands of tables with table name as table_1, table_2, table_3 ... from a schema in an Oracle database into another Oracle database. I only need to export the fields in the table structure and data that I defined in my search query. select field_1, field_2, filed_5, filed_10 where field_10<1000;
I also need to specify the list of table names for export as there are other tables in the schema that I do not need to export.
One table contains 5-7 millions of records. The amount of data for export is about 2-3TB. What would be good export and import tool? How can this be done?
Thanks in advance!