Compare table data

[Robertas]

Hello,
I have a problem on one table
When I compare table data with the same table in the other db I get CS_LC_STATE_OPERATION.STOP_SOK_CDSRID: column types are different in source and target database. When I do "Compate User Objects" - PSD say that there are no differences.
Here are the DDL's of source and target DB:

-- SOURCE
create table CS_LC_STATE_OPERATION
(
stop_id NUMBER not null,
stop_cdstid NUMBER not null,
stop_operid NUMBER,
stop_sok_cdsrid NUMBER,
stop_ser_cdsrid NUMBER,
stop_description VARCHAR2(250),
stop_status CHAR(1) default 'T' not null,
stop_sequence NUMBER(2) not null,
stop_cruserid VARCHAR2(30) not null,
stop_crdate DATE not null,
stop_mduser VARCHAR2(30),
stop_mddate DATE
)

-- TARGET
create table CS_LC_STATE_OPERATION
(
stop_id NUMBER not null,
stop_cdstid NUMBER not null,
stop_operid NUMBER,
stop_status CHAR(1) default 'T' not null,
stop_sequence NUMBER(2) not null,
stop_cruserid VARCHAR2(30) not null,
stop_crdate DATE not null,
stop_sok_cdsrid NUMBER,
stop_ser_cdsrid NUMBER,
stop_description VARCHAR2(250),
stop_mduser VARCHAR2(30),
stop_mddate DATE
)

PL/SQL Developer
Version 8.0.4.1514
01.62863 - 20 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 3, v.3311)

 

[Robertas]

I have noticed that this problem appears only when source and target table columns order do not match

Any comment on that?

 

[Marco Kalter]

We'll check it out.

 

[Robertas]

Hello Marco,

any news on this? We are planing big update and this feature plays quite a big role?

Thanks

 

[Marco Kalter]

Not yet, I will update here when we have any findings.

 

[Robertas]

Hello again Marco

Is there a possibility to have a patch for this problem soon?
Sorry for bothering You, but it is very important for me, because we are going to do a big upgrade next week

 

[Robertas]

Hello Marco,

It have been more than two months since my first post of the problem
Is there any news?