Database Backup and Recovery (MOSC)

MOSC Banner

export of a view in 9.2.0.3 and imported to version 9.2.0.8 changes its definition

edited Jun 2, 2011 8:39PM in Database Backup and Recovery (MOSC) 8 commentsAnswered
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",

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