Integration

We are copying an application from one DAD/database schema (/pls/scott_main pointing to SCOTT) to another (/pls/mydad pointing MYUSER), and the new schema should be open, while we won't the old schema to be there, but not open. The original DAD will need to remain open and accessible, because there are other applications there that will not be moved.
The application packages we are moving are all prefixed with "myapp_" .
So typically the application is called over the url http:myhost/pls/scott_main/myapp_main.startup . But there are other packages as well, for example /pls/scott_main/myapp_print.startup etc. There are over hundred myapp_* packages and procedures, and the all need to be closed.

My plan was to use mod_rewrite for this, to redirect all calls to /pls/scott_main/myapp* to some page (static or dynamic, doesn't matter) containing a message and the new url (just to the myapp_main package), and requesting the user to update his bookmark.

I must admit that my knowledge of greek (none) is better than my knowledge of regular expressions (none -1). I have checked the mod_rewrite docs, but I am unable to come up with anything that works. It could be that where the Rewriterule directive is located is of importance, as /pls url's are sent to the pls_handler mod_plsql.

But anyway:
Is anyone able to assist me with the rewrite rule required for my stunt:
redirect all calls to /pls/scott_main/myapp* to /pls/scott_main/page_moved.startup

I would be very grateful.
My Application server is AS10g v. 10.1.2.0.2 , with apache 1.3x, on windows platform.

Regards,
Jens

Edited by: h00173 on Sep 23, 2008 8:10 AM

Edited by: h00173 on Sep 23, 2008 11:54 PM

Edited by: h00173 on Sep 25, 2008 5:55 AM