oracle - How can I copy table data from one schema to a table of a different name in a different schema? -

i have table called census in prod schema, , table called census_backup in dev schema.

does toad have gui feature allow me copy table data prod.census dev.census_backup?

i know can copy table data dev schema using "copy data schema," seems that feature allow me copy data table of same name in dev schema.

i don't know if there existing feature in toad in graphical way , being able choose target table name.

however, why not using simple sql this, such as:

create table dev.census_backup select * prod.census; 

?

to user having grants create tables in dev schema , grant select in prod schema.