Copy a Pathcode, quickly

Quick way to duplicate a pathcode:
Central objects copy, takes about 40 mins.  Honestly, forget import and export and security and indexes and constraints…  Just do this:

select 'TRUNCATE TABLE PP910.' || table_name || ';' from all_Tables where owner = 'PP910' and length(table_name) < 12 and table_name not in ('DATACOUNTS', 'F983051_BAK', 'F98950BK') ;

 

select 'INSERT INTO PP910.' || table_name || ' SELECT * FROM PD910.' || table_name || '@jde_e1sys ;' from all_Tables where owner = 'PP910' and length(table_name) < 12 and table_name not in ('DATACOUNTS', 'F983051_BAK', 'F98950BK') ;

 

update pp910.f983051 set vrenhv = 'PP910' ;




Then copy the PD910\include and PD910\source dirs on the dep server to PP910 




Fix object librarian

create table jde.f9861srm as select * from ol910.f9861 where sipathcd = 'PD910' ;

delete from ol910.f9861 where sipathcd = 'PP910' ;

commit;

update jde.f9861srm set sipathcd = 'PP910' ;

insert into ol910.f9861 select * from jde.f9861srm ;

commit;




Full build and deploy.