Copy data from one database / table to another database / table in oracle using TOAD
A. Create a copy of the table in destination DB
1.In source DB in a schema browser window click on the table you want to copy, select "script" tab in the right part of the window: you will find the script to re-create your table; copy this script
2.Paste the script in a new SQL editor window in destination DB and run it. This should create the new table
B. Copy data in new table
1. In a schema browser window right click on table name in source DB
2. Select "Export Data" from context menu
3. Write "where" statement of your export query (leave it blank if you want to copy the entire table)
4. Select destination: clipboard
5. Click "ok" (now insert statements are stored in your clipboard)
6. Paste insert statements in a new SQL editor window in destination DB
7. Run statements as script (shortcut F5)
Through database link ( dblink )
INSERT INTO tool_service_mapping SELECT * FROM tool_service_mapping@<<db link to source database>>
No comments:
Post a Comment