Thursday, April 5, 2012

OWB10.1: Export of recently changed objects

Due to a hickup in communications a lot of changes where implemented in a OWB10.1 enviroment which we were migrating to OWB11gR2. To make things worse the changes weren't well documented. This meant I had to query the OWB10.1 repository (ALL_IV_ tables) to see which objects we changed and make the proper export to mdl statement:

select
'OMBEXPORT TO MDL_FILE ''$ExportDir/TAB_'||TABLE_NAME||
''' \
COMPONENTS (TABLE ''ENECO_DWH/'||SCHEMA_NAME||'/'||TABLE_NAME||''') \
OUTPUT LOG TO ''$LogDir/TAB_'||TABLE_NAME||'.log'';' as EXPORT_CMD
from OWB_OWN.ALL_IV_TABLES@load_p.world T
where T.UPDATED_ON >= to_date('1-jan-2012')
union all
select
'OMBEXPORT TO MDL_FILE ''$ExportDir/SEQ_'||SEQUENCE_NAME||
''' \
COMPONENTS (SEQUENCE ''ENECO_DWH/'||SCHEMA_NAME||'/'||SEQUENCE_NAME||''') \
OUTPUT LOG TO ''$LogDir/SEQ_'||SEQUENCE_NAME||'.log'';' as EXPORT_CMD
from OWB_OWN.ALL_IV_SEQUENCES@load_p.world T
where T.UPDATED_ON >= to_date('1-jan-2012')
union all
select 
'OMBEXPORT TO MDL_FILE ''$ExportDir/MAP_'||MAP_NAME||
''' \
COMPONENTS (MAPPING ''ENECO_DWH/'||INFORMATION_SYSTEM_NAME||'/'||MAP_NAME||''') \
OUTPUT LOG TO ''$LogDir/MAP_'||MAP_NAME||'.log'';' as EXPORT_CMD
from OWB_OWN.ALL_IV_XFORM_MAPS@load_p.world T
where T.UPDATED_ON >= to_date('1-jan-2012')
;

 Till Next Time