Print Thread
Diff script - alter table add constraint primary key using index
#65847 08/29/24 07:11 AM
Joined: Aug 2024
Posts: 5
R
Member
OP Offline
Member
R
Joined: Aug 2024
Posts: 5
There is a difference between DDL I wrote on one DB, and difference script PL/SQL Developer generated using Compare User Objects.

Real command:
--------------------
create unique index PK_POD_IDX on POD_POD (CISLO);
alter table POD_POD add constraint PK_POD primary key (CISLO) using index PK_POD_IDX;

PL/SQL Developer (compare user objects):
--------------------------------------------------------
create unique index PK_POD_IDX on POD_POD (CISLO);
alter table POD_POD add constraint PK_POD primary key (CISLO);

The problem is, that executing such command can result into different state of target DB.
Is there a way how to fix the generation of diff script?

PL/SQL Developer version 15.0.4.2064, DB Oracle 19c.

Thank you.

Last edited by Robert Mackovik; 08/29/24 07:13 AM.
Re: Diff script - alter table add constraint primary key using index
Robert Mackovik #65848 08/29/24 09:28 AM
Joined: Aug 1999
Posts: 22,361
Member
Offline
Member
Joined: Aug 1999
Posts: 22,361
That does indeed not seem right. We'll fix it!


Marco Kalter
Allround Automations
Re: Diff script - alter table add constraint primary key using index
Marco Kalter #65849 08/29/24 11:20 AM
Joined: Aug 2024
Posts: 5
R
Member
OP Offline
Member
R
Joined: Aug 2024
Posts: 5
Thank you very much.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.057s Queries: 14 (0.009s) Memory: 2.5032 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-10-14 11:47:01 UTC
Valid HTML 5 and Valid CSS