# transfering data between schemas **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [March 24, 2010, 5:37pm UTC](https://forums.toadworld.com/t/transfering-data-between-schemas/9376 "2010-03-24T17:37:39Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [March 24, 2010, 5:37pm UTC](https://forums.toadworld.com/t/transfering-data-between-schemas/9376/1 "2010-03-24T17:37:39Z")
We have another issue with our new Oracle 11g server that we did not see on our older one. Again, we have not been given DBA rights on the new machine so this might be the answer, but I doubt it. Both systems have/had auto commit off. We use TOAD to copy data from one schema to another. In the old server, the copy progressed and we could log in as that schema and see the data. IN the new world, the data seems to copy, but when we run over to the other schema we cant see it. Any ideas? Jerry ---
**Author:** ![MGainty](https://avatars.discourse-cdn.com/v4/letter/m/a5b964/32.png) [@MGainty](https://forums.toadworld.com/u/MGainty)\ **Post date:** [March 24, 2010, 6:36pm UTC](https://forums.toadworld.com/t/transfering-data-between-schemas/9376/2 "2010-03-24T18:36:21Z")
Good Evening Gerry- 2 different connection handles are used for 2 differerent schemas (even when they are on the same machine) make sure the DBA on both databases grants the necessary permissions (connect,all resources,select and or execute) on both databases to the user/password combination which the client will use to access the connection… HTH Martin Gainty * * * Note de déni et de confidentialité Ce message est confidentiel et peut être privilégié. Si vous n’êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l’expéditeur. N’importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l’information seulement et n’aura pas n’importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [March 24, 2010, 6:50pm UTC](https://forums.toadworld.com/t/transfering-data-between-schemas/9376/3 "2010-03-24T18:50:48Z")
Thanks Martin, I’ll have them check to make sure this is in place. Do you (or anyone following) know the command that TOAD uses when we copy data from the current schema to another? ---
**Author:** ![wimdelange\_062](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@wimdelange\_062](https://forums.toadworld.com/u/wimdelange_062)\ **Post date:** [March 25, 2010, 1:50am UTC](https://forums.toadworld.com/t/transfering-data-between-schemas/9376/4 "2010-03-25T01:50:49Z")
---
**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:** [March 25, 2010, 8:01am UTC](https://forums.toadworld.com/t/transfering-data-between-schemas/9376/5 "2010-03-25T08:01:48Z")
It sounds like a commit was never issued. ---
**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:** [March 25, 2010, 8:03am UTC](https://forums.toadworld.com/t/transfering-data-between-schemas/9376/6 "2010-03-25T08:03:34Z")
Toad uses insert statements with arrays in the bind variables. So one insert statement inserts as many rows as there are in the array. ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [March 25, 2010, 12:07pm UTC](https://forums.toadworld.com/t/transfering-data-between-schemas/9376/7 "2010-03-25T12:07:45Z")
Thanks again everyone – The issue turned out to be user error ! The tables were not identical. So it looks like it’s copying but never places the data in the second schema table because the structures are different. Signed, Feeling foolish. ---
**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:** [March 25, 2010, 12:10pm UTC](https://forums.toadworld.com/t/transfering-data-between-schemas/9376/8 "2010-03-25T12:10:18Z")
I have a note to myself to improve the error message in the next version so things like that will be more obvious.