Reference table is left blank on FK alter statement in generated table script (4241500)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Reference table is left blank on FK alter statement in generated table script
Beschreibung

When generating a table script, an alter statement for a foreign key constraint did not have the reference table listed. It was blank where the reference table should have been.

Here is an example:
ALTER TABLE schema1."table1" ADD (
CONSTRAINT "LongConstraintNameForTable1"
FOREIGN KEY ("Col1")
REFERENCES schema1.
ENABLE VALIDATE);
Ursache

This happens with constraints whose name is longer than 30 characters.
Lösung

WORKAROUND:
This is not an issue in versions 12.12 and earlier. Version 12.12 can be downloaded from here. It can be installed alongside your current version, so both can be used on the machine.

STATUS:
This issue is fixed in Toad for Oracle 13.2. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
Fehler-ID

TOR-3387

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel