On 5/8/20 12:32 AM, Jill Jade wrote:
Hello
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.
These are empty schemas that d
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 creat
Hello
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.
These are empty schemas that do not contain anything (tables, views etc).
On Fri, 2020-05-08 at 10:11 +0400, Jill Jade wrote:
> We have an issue with DB_Link from Oracle to PostgreSQL. When we try to
> access tables from
> Oracle database via DB_link, temp schemas(pg_temp,pg_toast) are automatically
> created
> in the database while using the query below.
>
> create t
