ORA-02025 - STREAMS ACCESSING DB2 ON Z/OS VIA DG4DB2 11.2.0.3
(Doc ID 1560248.1)
Last updated on FEBRUARY 07, 2019
Applies to:
Oracle Database Gateway for DRDA - Version 11.2.0.3 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |