Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » exporting/importing data through oracle application server (oracle app server ,rel 10.1.0.4.2,windows server 2003)
exporting/importing data through oracle application server [message #402053] Thu, 07 May 2009 07:42 Go to next message
merhanatef
Messages: 28
Registered: September 2008
Junior Member
Good morning ..

we are using oracle application server forms & reports services standalone release : 10.1.0.4.2,
developer suite 10g release 10.1.0.4.2
and database 10g release 10.2.0.1.0.

We can use the imp/exp utilities in our application to imp/exp certain data (specified in the form
built with forms builder) to dump files when connecting using oracle developer.
These dumps are sometimes needed & used later.

I was wondering if we can call these utilities through the application server
knowing that the bin of the app server doesn't contain these excutables (ie. imp.exe,exp.exe)
We tried copying them into the bin folder but calling them through a form didn't work & doesn't seem
to call the executables though their full path is specified in the form.

Is there a way to do it , imp/exp data through the application server?

Thanks in advance
Re: exporting/importing data through oracle application server [message #402125 is a reply to message #402053] Thu, 07 May 2009 12:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>knowing that the bin of the app server doesn't contain these excutables (ie. imp.exe,exp.exe)
These should be available in INFRA_HOME/bin.
If you are talking about exporting metadata from IASDB, I would
rather stick with built-in functionality like the one you have mentioned.
OAS has specific scripts to copy/move metadata.
>>Is there a way to do it , imp/exp data through the application server?
That I have no Idea.
Forms/Reports folks could help exactly.
A quick search in Google for "calling OS commands from FORMS"
could give a headstart.
Re: exporting/importing data through oracle application server [message #402134 is a reply to message #402053] Thu, 07 May 2009 15:14 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
merhanatef
calling them through a form didn't work
How did you do that? Did you use HOST built-in? Where did you put the DMP file? Was it accessible?
Previous Topic: Migrating database infrastructure / portal from RAC 32 bits to RAC 64 bit
Next Topic: Java problem
Goto Forum:
  


Current Time: Thu Mar 28 16:16:50 CDT 2024