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.
François Guertin** | **** Technical
Support Administrator, R&D**
Your Supply Chain Matters.™ - TECSYS
Tel.: (514) 866-5800 ext.4259 | Fax:
email@example.com | www.tecsys.com
De : John Dorlon [mailto:firstname.lastname@example.org]
Envoyé : 4 juin 2015 10:21
À : email@example.com
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,
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.