export of a view in 9.2.0.3 and imported to version 9.2.0.8 changes its definition
I wonder why the imported view from production (version 9.2.0.3) changes this line in Uat datbase (version 9.2.0.8)
In prod - this line:
AS
SELECT ASAP.TASK.*
FROM ASAP.ACCESS_SERVICE_REQUEST, ASAP.TASK
In Uat changed to this after import:
AS
SELECT ASAP.TASK."DOCUMENT_NUMBER",
TASK."TASK_NUMBER",
TASK."TASK_STATUS",
TASK."TASK_PRIORITY",
TASK."SCHEDULED_COMPLETION_DATE",
TASK."ACTUAL_COMPLETION_DATE",
TASK."ESTIMATED_COMPLETION_DATE",
TASK."LAST_MODIFIED_USERID",
TASK."LAST_MODIFIED_DATE",
TASK."TASK_TYPE",
TASK."CIRCUIT_DESIGN_ID",
TASK."WORK_QUEUE_ID",
TASK."WORK_QUEUE_PRIORITY",
TASK."ASSIGNED_FROM_WORK_QUEUE",
TASK."ASSIGNED_FROM_DATE",
TASK."TASK_STATUS_DATE",
In prod - this line:
AS
SELECT ASAP.TASK.*
FROM ASAP.ACCESS_SERVICE_REQUEST, ASAP.TASK
In Uat changed to this after import:
AS
SELECT ASAP.TASK."DOCUMENT_NUMBER",
TASK."TASK_NUMBER",
TASK."TASK_STATUS",
TASK."TASK_PRIORITY",
TASK."SCHEDULED_COMPLETION_DATE",
TASK."ACTUAL_COMPLETION_DATE",
TASK."ESTIMATED_COMPLETION_DATE",
TASK."LAST_MODIFIED_USERID",
TASK."LAST_MODIFIED_DATE",
TASK."TASK_TYPE",
TASK."CIRCUIT_DESIGN_ID",
TASK."WORK_QUEUE_ID",
TASK."WORK_QUEUE_PRIORITY",
TASK."ASSIGNED_FROM_WORK_QUEUE",
TASK."ASSIGNED_FROM_DATE",
TASK."TASK_STATUS_DATE",
0