Page 1 of 1

oracle scema compare ignore system generated invisible columns

Posted: 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

Re: oracle scema compare ignore system generated invisible columns

Posted: Mon 28 Oct 2019 12:08
by alexa
We will review this post and will answer you as soon as possible.

Re: oracle scema compare ignore system generated invisible columns

Posted: Tue 29 Oct 2019 08:07
by alexa
Could you please provide us the server's version and the CREATE definition of a sample table?

Re: oracle scema compare ignore system generated invisible columns

Posted: 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
);

Re: oracle scema compare ignore system generated invisible columns

Posted: Fri 01 Nov 2019 14:43
by alexa
Thank you for the reply.

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

Re: oracle scema compare ignore system generated invisible columns

Posted: 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

Re: oracle scema compare ignore system generated invisible columns

Posted: Tue 26 Nov 2019 13:11
by alexa
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 .

Re: oracle scema compare ignore system generated invisible columns

Posted: 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

Re: oracle scema compare ignore system generated invisible columns

Posted: Wed 04 Dec 2019 11:17
by alexa
We sent you a trial period extension for dbForge Schema Compare for Oracle by e-mail.