Wednesday, July 8, 2009

Register Apex component using DBMS_REGISTRY

Hello,

As far as you know APEX RTF Templates use a lot of TABLESPACE space. Due to it
comes the need to defragment tablespace where APEX "live". The simples way is to export APEX schema and import it again.
After this actions I found that APEX component was removed from Oracle registry (dba_registry view), and some functionality invalidated.

So, I want to show how to register APEX again.
As a SYS user execute next procedures:

//This procedure emulate APEX v3.2 loading
exec dbms_registry.loading('APEX','Oracle Application Express','validate_apex', 'APEX_030200');

//Save APEX version
exec dbms_registry.loaded('APEX', '3.2.0.00.27');

//Make APEX to be a valid component
exec dbms_registry.valid('APEX');

//Add additional schemes to registry
exec dbms_registry.update_schema_list('APEX', dbms_registry.schema_list_t('FLOWS_FILES'));

That's it!
Google