# Copy ONE table in Toad Xpert 12.5

**URL:** <https://forums.toadworld.com/t/copy-one-table-in-toad-xpert-12-5/30620>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [August 6, 2014, 10:18am UTC](https://forums.toadworld.com/t/copy-one-table-in-toad-xpert-12-5/30620 "2014-08-06T10:18:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jumboshrimps](https://avatars.discourse-cdn.com/v4/letter/j/ed655f/32.png) [@Jumboshrimps](https://forums.toadworld.com/u/Jumboshrimps)\
**Post date:** [August 6, 2014, 10:18am UTC](https://forums.toadworld.com/t/copy-one-table-in-toad-xpert-12-5/30620/1 "2014-08-06T10:18:50Z")

</div>

I need to copy several ORACLE tables on schemas on different servers.

I open Schema Browser, right click on the table I want to copy and select Copy Data to Another Schema.

I select other Schema I’m connected to and press execute.

I get an error message  
“Error Message:  
ORA-00942: table or view does not exist”

NO KIDDING!!! THAT’S WHY I’M COPYING THE TABLE!!!

Second option is to right click on the table in the Schema Browser

again, and select “Create in Another Schema”.

I select other schema, select execute and get an error message:

“ORA-00942: table or view does not exist”

REALLY??? OF COURSE IS DOESN’T EXIST, THAT’S WHY I’M COPYING IT!!!

I just to select a table from one schema drag-and-drop it to the other schema.

Is that possible?

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [August 6, 2014, 10:46am UTC](https://forums.toadworld.com/t/copy-one-table-in-toad-xpert-12-5/30620/2 "2014-08-06T10:46:48Z")

</div>

The copy table needs access to some data dictionary tables to figure out all the DDL in order to copy the table - so in the second case the error message is telling you that you don’t have correct priv’s to execute the copy function. Did you check option in toad to check dba\_ tables if they exist? Do you have database priv select any catalog role?

---

<div class="post-metadata">

**Author:** ![cyberlaze](https://avatars.discourse-cdn.com/v4/letter/c/c0e974/32.png) [@cyberlaze](https://forums.toadworld.com/u/cyberlaze)\
**Post date:** [September 22, 2020, 6:02pm UTC](https://forums.toadworld.com/t/copy-one-table-in-toad-xpert-12-5/30620/3 "2020-09-22T18:02:29Z")

</div>

i had that same error even i'm using system or even "sys as dba" ORA-00942: table or view does not exist

---

<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:** [September 22, 2020, 7:54pm UTC](https://forums.toadworld.com/t/copy-one-table-in-toad-xpert-12-5/30620/4 "2020-09-22T19:54:31Z")

</div>

If you are using an old version of Toad on a new(er) version of Oracle, that could be the cause for this message.

From the main menu, click Database -\> Spool SQL -\> Spool to screen. That will make all of the SQL that Toad runs display in a window at the bottom of Toad. Now do whatever you were doing before to get the error. That way you can find the SQL that Toad is running which causes the error. If you post that SQL here (no need to post the entire script) I can hopefully tell you which option to uncheck so it doesn't happen.