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.
No comments:
Post a Comment