Last updated on JUNE 07, 2013

Applies to:

Symptoms

Using Oracle Database Gateway for DRDA version 11.2.0.3, running RHEL6 Linux x86_64, a select statement generated by Oracle Streams 11.2.0.3 results in this error when running from sqlplus. Also the same error is happening when running the Streams Apply process.

SELECT AC.COLUMN_ID, 1, 1, CD.CONSTRAINT_TYPE FROM (SELECT OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_TYPE_MOD, DATA_TYPE_OWNER, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE, COLUMN_ID, DEFAULT_LENGTH, DATA_DEFAULT, NUM_DISTINCT, LOW_VALUE, HIGH_VALUE, DENSITY, NUM_NULLS, NUM_BUCKETS, LAST_ANALYZED, SAMPLE_SIZE, CHARACTER_SET_NAME, CHAR_COL_DECL_L CHAR_COL_DECL_LENGTH, GLOBAL_STATS, USER_STATS, AVG_COL_LEN, CHAR_LENGTH, CHAR_USED, V80_FMT_IMAGE, DATA_UPGRADED, HISTOGRAM FROM OTGDB2.ALL_TAB_COLUMNS102@DRDA) AC, (SELECT OWNER, CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME, SEARCH_CONDITION, R_OWNER, R_CONSTRAINT_NAME, DELETE_RULE, STATUS, DEFERRABLE, DEFERRED, VALIDATED, GENERATED, BAD, RELY, LAST_CHANGE, INDEX_OWNER, INDEX_NAME, INVALID, VIEW_RELATED FROM OTGDB2.ALL_CONSTRAINTS@DRDA) CD, (SELECT OWNER, CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME, POSITION FROM OTGDB2.ALL_CONS_COLUMNS@DRDA) CC, SYS.OBJ$ O WHERE O.REMOTEOWNER = 1 AND O.NAME = 2 AND O.TYPE# = 2 AND O.LINKNAME = 'DRDA' AND AC.TABLE_NAME = O.NAME AND AC.OWNER = O.REMOTEOWNER AND CD.TABLE_NAME = O.NAME AND CD.OWNER = O.REMOTEOWNER AND CD.CONSTRAINT_TYPE IN ('P','U','R') AND CD.OWNER = CC.OWNER AND CD.CONSTRAINT_NAME = CC.CONSTRAINT_NAME AND AC.COLUMN_NAME = CC.COLUMN_NAME ORDER BY CC.POSITION
*
ERROR at line 1:
ORA-02025: all tables in the SQL statement must be at the remote database

This same generated query works fine when using version 11.1.0.7 of the Oracle Database Gateway for DRDA from sqlplus and from Streams Apply process.

Cause