Is it possible to create a table (in my dev db) using a SELECT from a different database?
I want something like:
create tmp_table as select * from prod_db.prod_schema.table
You have to create a datalink first.
Oracle cannot query other databases unless a DB link is created. If a DB link exists, as you remarked, you have to do :
create tmp_table as select * from prod_schema.table@prod_db