oracle scema compare ignore system generated invisible columns
-
- Posts: 2
- Joined: Thu 24 Oct 2019 18:34
oracle scema compare ignore system generated invisible columns
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
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
We will review this post and will answer you as soon as possible.
Re: oracle scema compare ignore system generated invisible columns
Could you please provide us the server's version and the CREATE definition of a sample table?
-
- Posts: 2
- Joined: Thu 24 Oct 2019 18:34
Re: oracle scema compare ignore system generated invisible columns
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
);
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
Thank you for the reply.
We will investigate this issue and will answer you as soon as possible.
We will investigate this issue and will answer you as soon as possible.
-
- Posts: 2
- Joined: Thu 24 Oct 2019 18:34
Re: oracle scema compare ignore system generated invisible columns
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
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
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 .
Screenshots or video would be also of help.
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
- Posts: 2
- Joined: Thu 24 Oct 2019 18:34
Re: oracle scema compare ignore system generated invisible columns
Unfortunately, the trial version I used for testing this version is no longer valid.
I'll resume testing when possible.
israel
I'll resume testing when possible.
israel
Re: oracle scema compare ignore system generated invisible columns
We sent you a trial period extension for dbForge Schema Compare for Oracle by e-mail.