oracle scema compare ignore system generated invisible columns

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
israel_s@gadir.co.il
Posts: 4
Joined: Thu 24 Oct 2019 18:34

oracle scema compare ignore system generated invisible columns

Post by israel_s@gadir.co.il » Thu 24 Oct 2019 19:16

Hello,
I'm using schema compare v 4.1.20.
When comparing I have in one schema system-generated VIRTUAL INVISBLE columns with names starting with sys_sts....
How do I ignore these columns when comparing?
If those columns cannot be ignored then I have to check almost all tables manually as these columns appear in almost all tables in one schema.

TIA,
israel

alexa
Devart Team
Posts: 2885
Joined: Fri 24 Jun 2011 14:17

Re: oracle scema compare ignore system generated invisible columns

Post by alexa » Mon 28 Oct 2019 12:08

We will review this post and will answer you as soon as possible.

alexa
Devart Team
Posts: 2885
Joined: Fri 24 Jun 2011 14:17

Re: oracle scema compare ignore system generated invisible columns

Post by alexa » Tue 29 Oct 2019 08:07

Could you please provide us the server's version and the CREATE definition of a sample table?

israel_s@gadir.co.il
Posts: 4
Joined: Thu 24 Oct 2019 18:34

Re: oracle scema compare ignore system generated invisible columns

Post by israel_s@gadir.co.il » Tue 29 Oct 2019 13:24

version:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

sample table:
create table XT.TEST1
(
number_id NUMBER(9),
)
tablespace GELEC
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);

alexa
Devart Team
Posts: 2885
Joined: Fri 24 Jun 2011 14:17

Re: oracle scema compare ignore system generated invisible columns

Post by alexa » Fri 01 Nov 2019 14:43

Thank you for the reply.

We will investigate this issue and will answer you as soon as possible.

israel_s@gadir.co.il
Posts: 4
Joined: Thu 24 Oct 2019 18:34

Re: oracle scema compare ignore system generated invisible columns

Post by israel_s@gadir.co.il » Wed 13 Nov 2019 11:01

Hello,
When can I expect an answer?
I really want to upgrade to the new version but this is a big problem right now.


israel

alexa
Devart Team
Posts: 2885
Joined: Fri 24 Jun 2011 14:17

Re: oracle scema compare ignore system generated invisible columns

Post by alexa » Tue 26 Nov 2019 13:11

Could you please provide us the Source and Target tables?

Screenshots or video would be also of help.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

israel_s@gadir.co.il
Posts: 4
Joined: Thu 24 Oct 2019 18:34

Re: oracle scema compare ignore system generated invisible columns

Post by israel_s@gadir.co.il » Tue 03 Dec 2019 17:02

Unfortunately, the trial version I used for testing this version is no longer valid.
I'll resume testing when possible.

israel

alexa
Devart Team
Posts: 2885
Joined: Fri 24 Jun 2011 14:17

Re: oracle scema compare ignore system generated invisible columns

Post by alexa » Wed 04 Dec 2019 11:17

We sent you a trial period extension for dbForge Schema Compare for Oracle by e-mail.

Post Reply