postgres fdw create foreign table without specifiy columns
This is what IMPORT FOREIGN SCHEMA is for.  You can run it for a single table at a time if you want to.

oracle_fdw says it supports IMPORT FOREIGN SCHEMA, but be sure to read that section of the docs for more info.