how to export data from one table to another in oracle?
['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).']