Compare User Object GTT table diff problem

[akaya]

Hi,

Suppose I have a global temp table in development, and that table is not a global temp table in test environment.

When I try to apply the difference using Compare User Objects feature, this difference is not listed.

Please check and advise.

 

[Marco Kalter]

The Compare User Objects tools will not list differences that require the recreation of a table.

 

[akaya]

How do you suggest these kind of changes be tracked?

 

[Marco Kalter]

In general if you change the table organization (which should hopefully not occur frequently) then you will probably need to make a script that saves the table data, drops the table, recreates the table and populates it from the saved data.