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!

4 comments:

Anonymous said...

Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!

Anonymous said...

Amiable post and this mail helped me alot in my college assignement. Say thank you you as your information.

Term Papers said...

I have been visiting various blogs for my term papers writing research. I have found your blog to be quite useful. Keep updating your blog with valuable information... Regards

Anonymous said...

thanks for this tips

Google