How to create a table and export its data from one schema directly into another schema?
RESOLUTION 1:
1) Go to Schema Browser | Tables | right-click the ‘Source’ table, the table to import to another schema
2) Choose “Create in another schema”
3) Go to “Tables” Tab | check-mark “Insert Statements”
4) Click “OK
5) Choose the Destination schema (Note: Click on “Script” Tab to preview the script that Toad will run)
6) Click Execute
7) Toad will ask for the login password of the Destination Schema.
Note: If ORA errors occur, check the generated script. For example, Toad could throw the error, “DROP TABLE… ORA-00942: table or view does not exist”, which would be a valid error if the table name does not exist in the Destination Schema.
8) Check if the table is created in the Destination Schema and if the table data is also copied over
