Jill Jade schrieb am 08.05.2020 um 09:32: > We do not have any temporary tables in the Oracle database. The > temporary schema is created only while using the db_link. These temp > schemas (pg_temp, pg_toast) are not disappearing even after > restarting the database.
The temp tables would be created in Postgres, not in Oracle. > Why the db_link is causing these schemas? Is there any issue with db_link? Which DB_Link are you referring to exactly? Postgres' "dblink" module can only connect to another Postgres server. So it must be something on the Oracle side.
