The following example uses the PASS THROUGH operation on the Teradata system to allow DDL and DCL queries to be run on Oracle, as supported by the Oracle target connector.
call syslib.executeforeignsql('CREATE TABLE rowid1(a rowid)','oraclefs_active');