PL/SQL (MOSC)

MOSC Banner

global temporary table issue

edited Feb 19, 2012 4:26PM in PL/SQL (MOSC) 6 commentsAnswered
i have 2 environment 1) development 2)production

in development oracle version is-
----------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0    Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

in prodcution
-----------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0    Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

we are using two global temporary tables (tmp_transaction    tmp_category_mv)(development and production).
Both are contains the same data set. I have compared the data set.all are same.
but the query return different set in development environment.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center