Hi,
With Oracle 12C we can define a sequence as a default value for a column.
We I compare two schemas, Toad will show a difference for each column using this feature because the owner of the sequence is different for each schema. Is there a way to tell Toad to ignore the schema name of the sequence when comparing default value?
I have attached a axample of the difference.
Thanks
Hmm, I think that was overlooked. I’ll take care of it when we get into betas again.
For now, on the results tab of the schema compare, you can uncheck the items that you don’t want to appear in the sync script.
Looking at this a bit more closely…
if you define your table like this, then you will have some extra benefits:
You don’t have to create your sequence separately, nor worry about it being dropped (Oracle won’t let anyone drop it separately from the table)
Toad won’t identify it as a difference between schemas.
CREATE TABLE IDENT_TEST
(
COL1 NUMBER Generated as Identity,
COL2 VARCHAR2(10),
COL3 DATE
)
Hi John,
We first thought about using this method. The problem with it is that we want to control what the name of the sequence is as we need to reference it later.
When we create it the way you describe, Oracle generates the name of the sequence and it will be more difficult to get the name of it.
Thanks
François Guertin** | **** Technical
Support Administrator, R&D**
Your Supply Chain Matters.™ - TECSYS
Tel.: (514) 866-5800 ext.4259 | Fax:
(514) 866-3878
francois.guertin@tecsys.com | www.tecsys.com
De : John Dorlon [mailto:bounce-jdorlon@toadworld.com]
Envoyé : 4 juin 2015 10:21
Objet : RE: [Toad for Oracle - Discussion Forum] Oracle schema compare with sequences as default value
RE: Oracle schema compare with sequences as default value
Reply by John Dorlon
Looking at this a bit more closely…
if you define your table like this, then you will have some extra benefits:
You don’t have to create your sequence separately, nor worry about it being dropped (Oracle won’t let anyone drop it separately from the table)
Toad won’t identify it as a difference between schemas.
CREATE TABLE IDENT_TEST
(
COL1 NUMBER Generated as Identity,
COL2 VARCHAR2(10),
COL3 DATE
)
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
OK, it should be fixed for the first beta after 12.7 is released. The side-by-side viewer will still identify this as a difference because it is just a dumb text compare, but the schema compare will not flag this as a difference (so the only reason you’d see it in the side-by-side viewer is if there were some other difference on the table)
