Data sources that automatically commit DDL statements

Some data sources, such as Oracle, automatically commit the current transaction at their data source sites as part of a DDL statement execution.

If you create a remote table using transparent DDL or in a pass-through session, these data sources cannot rollback the remote table after the table is created. You must delete the remote table manually.