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
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?