create tmp_table as select * from prod_db.prod_schema.table

create tmp_table as select * from prod_schema.table@prod_db

create tmp_table as select * from table@dblink

SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name)
     FROM USER_INDEXES u;