The strategy you propose is error-prone. Instead, write a script to do one or more INSERT SELECTs from one schema into the other. Check your work. If the second schema was loaded properly, COMMIT it. If not, ROLL it BACK, modify your script, and execute again.
Sheldon Linker (firstname.lastname@example.org)
Linker Systems, Inc. (www.linker.com)