Spatial component in upgrade R12.1.3

Posted by satish on Nov 05, 2022; 2:41am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Spatial-component-in-upgrade-R12-1-3-tp11199.html

Dear erman,

We have upgraded  ebs 11.1.0.7 to 11.2.0.4.We found below script took long time to complete.Any suggestions please?

prvtimd.plb took more than 10 hours to complete.

prvtimd.pib

SQL> declare
2 begin
3 begin
4 execute immediate
5 ' ALTER TABLE sdo_index_metadata_table
RENAME' I
6 ' COLUMN sdo_root_mbr to old _sdo_root_mbr';
7 exception when others then null;
8 end;
9
10 begin
11 execute immediate
12
'ALTER TABLE sdo_index_metadata_table
13 'ADD (SDO ROOT MBR mdsys.sdo_geometry default null)';
14 exception when others then null;
15 end;
16
17 begin
18 execute immediate
19 ' UPDATE sdo index metadata table set
sdo_root_mbr = old _sdo_root_mbr';
20 exception when others then null;
21 end;
22
23 begin
24 execute immediate
25 'ALTER TABLE so_index_metadata_table
DROP(old_sdo_root_mbr)';
26 exception when others then null;
27 end;
28 end;
29 /
PL/SQL procedure successfully completed.

Elapsed: 11:12:11.15

Thanks,
Satish