Incorrect Query Results With Autorefresh using ISREFRESHED (Doc ID 1161883.1)

Last updated on JUNE 17, 2016

Applies to:

Workspace Manager - Version 11.1.0.7.0 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms


Comments
--------
Within Oracle's Workspace Manager, using the ISREFRESHED parameter, set to true, when creating a new Workspace, the "continually refreshed workspace" portion does not work:

For Example:

The current workspace is: OWM_P1
SQL> SELECT 'Number of rows in parent (should be 1): '||COUNT(1) FROM TESTOWM WHERE PID=7;

Number of rows in parent (should be 1): 2

SQL> SELECT PID, MYVAL FROM TESTOWM WHERE PID=7;

7 621705.966
7 1984

SQL> EXEC DBMS_WM.GOTOWORKSPACE('OWM_P2');
SQL> EXEC DBMS_WM.SetWoOverwriteOFF();
SQL> SELECT 'The current workspace is: '||DBMS_WM.GetWorkspace FROM DUAL;

The current workspace is: OWM_P2

SQL> SELECT 'Number of rows in other parent (should be 1): '||COUNT(1) FROM TESTOWM WHERE PID=7;

Number of rows in other parent (should be 1): 2

SQL> SELECT PID, MYVAL FROM TESTOWM WHERE PID=7;

7 621705.966
7 1991

SQL> EXEC DBMS_WM.GOTOWORKSPACE('LIVE');
SQL> SELECT 'The current workspace is: '||DBMS_WM.GetWorkspace FROM DUAL;

The current workspace is: LIVE

SQL> SELECT 'Number of rows in LIVE (should be 1): '||COUNT(1) FROM TESTOWM
WHERE PID=7;

Number of rows in LIVE (should be 1): 1

SQL> SELECT PID, MYVAL FROM TESTOWM WHERE PID=7;

7 621705.966

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms