Closed mattyschell closed 2 years ago
create table map_librarybak as select * from map_library; alter table map_librarybak drop column objectid; --drop in catalog rename map_librarybak to map_library; alter table map_library add primary key (id); grant select on map_library to "MAP_VIEWER";
Alternative to workaround above. This one is faster and doesn't bump up against temp tablespace limitatations.
rename map_library to map_librarybak2; create table map_library as select * from map_librarybak2 where rownum = 1; -- drop map_library in arccatalog to fool the old boy alter table map_librarybak2 drop column objectid; rename map_librarybak2 to map_library; alter table map_library add primary key (id); grant select on map_library to "MAP_VIEWER";
Closing, tracking under #21
Same underlying issue as #14