I installed toad 17 and use toad compare via the command-line.
I noticed toad now generates a "CREATE PACKAGE" io "CREATE OR REPLACE PACKAGE", resulting in an oracle error when patching.
When saving the options clipboard, a noticed a new option "CreateOrReplace" not available via the UI (did not found documentation on this in the help menu).
Is this a bug are new behaviour?
Hi Christopher,
I just did a schema compare and the sync script is creating objects with "create or replace", not create.
When saving the options clipboard, a noticed a new option "CreateOrReplace" not available via the UI (did not found documentation on this in the help menu).
Yes, there is no option for just "create" in schema compare. It should only do "create or replace".
Can you send me your schema compare action?
-John
Hi John
I used UTILS_DAO.ini in the attachment.
Resulting in SyncScript. (see lines 33 and 291)
Christophe
(Attachment UTILS_DAO.ini is missing)
SyncScript.sql (25.6 KB)
renamed utils_dao.ini to utils_dao.txt
UTILS_DAO.txt (1.76 KB)
Oh, you are using a parameter file.
You can fix it by adding CreateOrReplace to the list of items after "Options" section. It can be anywhere in the list.
I'll fix Toad so that this is not necessary.