Skip to Main Content

SQLcl

Announcement

Testing banner

lb problems with Tables with primary key in separate index

Neil BarsemaDec 31 2022 — edited Dec 31 2022

Hi

I have a problem importing tables from my schema, I have managed to reduce the problem to this.
If you create a table like:
create table example
( ex_id number,
primary key (ex_id)
using index (create unique index i_ex_pk on example(ex_id))
);
The lb generate_object works fine and the resulting XML file validates but lb update fails.

Comments
Post Details
Added on Dec 31 2022
15 comments
53 views