I am looking for ways to Export/Import Related data in multiple tables from one environment to another. The table structures remain the same. I found ways to export data from multiple tables with individual SQL in TOAD in one script, but I am looking for exporting related data only. Say for instance get CUSTID, CUSTNAME FROM customers table and then get all the employees tied to that CUSTID in EMP table by extracting EMPID,EMPNAME,CUSTID.
I would like to then use the Import or Load utility to load that data in a different set of tables.