Thanks for the reply.
But What I meant is I wanted the ILM assistant up and running in my Oracle XE, but the managed database is in my ORCLDB (10g EE).
Is the any possible way? because I don't want to install anything (HTTP server, application Server, Oracle Text) to my 10g EE.
Ah ... remote access is a very desirable feature. Unfortunately, we have not yet implemented it within the ILM Assistant. At this point, I do not know of any work-around that keeps all pieces off your target enterprise system. One thing to note is that you could install just the APEX and ILM Assistant PL/SQL packages on the target system. Then, you could use the PL/SQL gateway and avoid having the HTTP server on the same box as your enterprise. Would that work for you?
Thanks for the reply,
Is there any step by step guidance to do like you suggested me? (Install just the APEX and ILM Assistant PL/SQL packages on my DB 10g EE and install PL/SQL gateway and HTTP server on my 10g XE).
Anyway, you install Apex and ILMA on your ee system just like you would on any machine. Next, you have to set up the PL/SQL gateway on the ee system so it can find Apex on your ee machine. Once that is done, your remote browser should be able to find the ILM Assistant. One thing to note, Apex and ILMA are both just PL/SQL-based packages that run on the target machine. The thing you're trying to do is invoke the Apex PL/SQL procedures from your browser, which may or may not be located on the same physical box as your ee system.
I've not personally used or set up the gateway, but I know of others who have had success with it.