Question: how to export data from one table to another in oracle?
Answer: On the tool bar, select Tools>Database copy. Identify source and destination connections with the copy options you would like. For object type, select table(s). Specify the specific table(s) (e.g. table1).