I haven't actually done that, but in the Register Functions dialog in Discoverer Admin, there's a drop down for "Database Link". Can you change that to "database A" instead of "Default Database"? Then when you select import, does the function show up in the list?
tried that. Did not work.
You mention you are unable to see the function in Database B. Do you mean from other than Discoverer Administration (Admin), using another tool?
I am not clear on exactly what you are attempting to do. I can say that you cannot have two Functions registered by the same name.
Premier support for Discoverer 11g ended June 2014. Version 188.8.131.52.0 is the final / terminal release of the Discoverer product. Discoverer is under sustaining support, which limits our ability to assist you. Please review the alert section at the bottom of this update.
Discoverer is at end of life. Any software update (OS, browser, Java, WLS, EBS, etc.) released after June 2014 has not specifically been certified or tested and may cause issues for Discoverer. Therefore, it is important to maintain a stable Discoverer environment for as long as it takes to move to OBIEE or other replacement.