Is there a way to copy data from a table in one schema to a table in another schema?
1. In the Schema Browser's Table tab, highlight the table(s) data you want to export.
2. Right click in the table tab area and choose "Copy data to another schema"
3. Fill out information in the copy data window.