APPS.BIM_DBI_SCM_RSG_API_PVT dependencies on DBMS_METADATA
Line 35: VALUES (i.index_name,p_obj_name,REPLACE(DBMS_METADATA.GET_DDL('INDEX',i.index_name),'COMPUTE STATISTICS',NULL)||' NOLOGGING PARALLEL'); -- Log the index ddl syntax
31:
32:
33: FOR i in c_obj_indexes(p_obj_name,null) LOOP
34: INSERT INTO bim_all_indexes (INDEX_NAME,TABLE_NAME,COLUMN_NAME) 35: VALUES (i.index_name,p_obj_name,REPLACE(DBMS_METADATA.GET_DDL('INDEX',i.index_name),'COMPUTE STATISTICS',NULL)||' NOLOGGING PARALLEL'); -- Log the index ddl syntax 36: execute immediate ('drop index '||i.index_name); -- drop the index
37: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('MetaData Information Recorded and Index Dropped for Index :'||i.index_name);
38: END LOOP;
39: