# copy data to another schema does not generate a script as in 10.1

**URL:** <https://forums.toadworld.com/t/copy-data-to-another-schema-does-not-generate-a-script-as-in-10-1/33722>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 8, 2015, 8:05am UTC](https://forums.toadworld.com/t/copy-data-to-another-schema-does-not-generate-a-script-as-in-10-1/33722 "2015-07-08T08:05:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Newbee\_sunit](https://avatars.discourse-cdn.com/v4/letter/n/c68b51/32.png) [@Newbee\_sunit](https://forums.toadworld.com/u/Newbee_sunit)\
**Post date:** [July 8, 2015, 8:05am UTC](https://forums.toadworld.com/t/copy-data-to-another-schema-does-not-generate-a-script-as-in-10-1/33722/1 "2015-07-08T08:05:39Z")

</div>

Hi people,

I am new to toad.

Can you please help me out here.

In toad 10.1 to copy multiple tables to a different schema . there was an option to save the script and re run it .

which was very useful to the work i do. but i dont see the option in toad 12.6 (i.e i cannot save a script for re use)

sample script that i could generate and reuse:

# 

# You can run the data copy utility from a command line

# using this file with a few modifications.

# 

# Anything after a ‘#’ in any line will be ignored as a comment.

# 

# Calling TOAD like this will perform a data copy from command line :

# 

# “M:\WINPROG\TOAD10\Toad.exe” -c “DZ445/\<8,0,0,0,209,188,70,199,131,47,99,152,32,114,182,193,112,224,0,168\>@TCS.WORLD” DATACOPY="\res09\ndrive\ol230.OAAD\Gourav\Client Query\Helmut\14-May-2013\expsecurty.txt"

# 

# (obviously, your path to TOAD may differ, along with your connect info.

# The file name after “DATACOPY=” is the name of this file.)

# 

# Uncomment the following line if you wish to close TOAD when the data copy is complete.

#CloseTOAD

# 

# 

# You may edit this file, but you must observe the following rules:

# 1) The “DestSchemaName” line should be commented out if source tables

# are from multiple schemas. It should NOT be commented out (ie, it

# is required) if source tables are all from one schema.

# 2) If required, “DestSchemaName” should be specified AFTER connection info.

# 3) Line feeds in ‘where’ clauses must be represented by {NL}

# Not following this line feed representation will cause part of

# your ‘where’ clause to be ignored.

# 

# 

# Connect Info…

CONNECTSRC=DZ445/\<8,0,0,0,209,188,70,199,131,47,99,152,32,114,182,193,112,224,0,168\>@TCS.WORLD  
CONNECTDEST=TCS\_SR2012/\<10,0,0,0,172,129,144,68,86,209,130,204,107,0,171,3,236,86,66,48\>@TCS\_ERI2.DEV

# 

# Table listings…

TABLE=TCS\_OWNER.AC\_CUSTODIAN\_MSTR  
WHERECLAUSE[TCS\_OWNER.AC\_CUSTODIAN\_MSTR]= where sec\_id in (‘027339778’){NL}  
TABLE=TCS\_OWNER.AC\_IDENTIFICATION  
WHERECLAUSE[TCS\_OWNER.AC\_IDENTIFICATION]=where sec\_id in (443893) {NL}  
TABLE=TCS\_OWNER.AC\_SEC\_HLDNGS\_HSTRY  
WHERECLAUSE[TCS\_OWNER.AC\_SEC\_HLDNGS\_HSTRY]= where secid in (‘027339778’){NL}  
TABLE=TCS\_OWNER.AC\_SEC\_MSTR  
WHERECLAUSE[TCS\_OWNER.AC\_SEC\_MSTR]= where sec\_id in(443893) {NL}  
TABLE=TCS\_OWNER.SCRTY\_ADDTNL\_DTLS  
WHERECLAUSE[TCS\_OWNER.SCRTY\_ADDTNL\_DTLS]=where secid in(443893) {NL}

# 

# Other Settings…

DestSchemaName=TCS\_SR2012  
Truncate=N  
Reuse=N  
ArraySize=500  
RollbackSegment=No Specific RBS  
CommitOption=1

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 8, 2015, 8:13am UTC](https://forums.toadworld.com/t/copy-data-to-another-schema-does-not-generate-a-script-as-in-10-1/33722/2 "2015-07-08T08:13:55Z")

</div>

This and most of the other old command line features have been moved into the Automation Designer. Look for the toolbar icon that looks like a lightning bolt with a pencil next to it. Click it.

On the Import/Export tab, you’ll find an icon for “copy table data”. Click that and then click to drop it in the area below. Then you can set the properties on it and save the action for reuse there. Check the docs on how to schedule or run from command line.

If you still have questions, let us know.

---

<div class="post-metadata">

**Author:** ![Newbee\_sunit](https://avatars.discourse-cdn.com/v4/letter/n/c68b51/32.png) [@Newbee\_sunit](https://forums.toadworld.com/u/Newbee_sunit)\
**Post date:** [July 9, 2015, 2:42am UTC](https://forums.toadworld.com/t/copy-data-to-another-schema-does-not-generate-a-script-as-in-10-1/33722/3 "2015-07-09T02:42:59Z")

</div>

Thanks a ton John exactly wat i needed.