I use TOAD 25.2 beta :
Menu Export / Generate schema script / one schema selection,
Object type to extract, uncheck all, keep only Indexes + Constraints without Check,
The generate script has only indexes, no constraints on tables :
In the second case I have these comments at the end : (but no constraints)
-- Note:
-- The following objects do not have associated statements.
-- ETD_CTRL_SCHEMA_BOIRON (Table)
-- ETT_APPEL_ENTRANT (Table)
-- ETT_ARTI (Table)
-- ETT_AUTHENTIF (Table)
-- ETT_BAC_RAM (Table)
-- ETT_BOUCLAGE (Table)
-- ETT_BR (Table)
-- ETT_CAMP_APPEL (Table)
…
If I uncheck Indexes, (and keep constraints) nothing is generated.
Hi,
Can you provide some detailed steps to reproduce the problem?
I know that the extraction of constraints is not completely broken, and without details I can't help you.
Thanks
I have a schema in a 19c database, with many tables, with index and constraints PK and FK. I want to export just for a script with only constraints PK and FK. So ALTER TABLE ADD constraint PRIMARY and FOREIGN ...
Example :
ALTER TABLE OPS$ETDRCT.ETT_ANCIEN_UL ADD (
CONSTRAINT ETT_ANCIEN_UL_PK
PRIMARY KEY
(ID_ANCIEN_UL)
DEFERRABLE INITIALLY IMMEDIATE
USING INDEX OPS$ETDRCT.ETT_ANCIEN_UL_PK
ENABLE VALIDATE);
ALTER TABLE OPS$ETDRCT.ETT_ANCIEN_UL ADD (
CONSTRAINT ETT_ANCIEN_UL_FK_1
FOREIGN KEY (ID_EXPED)
REFERENCES OPS$ETDRCT.ETT_EXPED (ID_EXPED)
DEFERRABLE INITIALLY IMMEDIATE
ENABLE VALIDATE);
Thank you.
I can reproduce this and will fix.
Sorry for the abruptness of my first response. I see that you did provide steps initially.
I have noticed that if you include Check Constraints, then all constraints will appear.
If you don't like that workaround, you can select the constraints on the Object Listing, then click the "Script" button.
Thanks for this workaround.
You're welcome. Also, it is fixed in the beta just released.
