Saving / Eporting Ora 9i DB via ODBC in .dmp file

Hi Together!

We have here a Java Application which is connected to an Oracle 9i DB via ODBC.

For saving different version of the content in the DB we used the oracle export tool and saved the DB in a .dmp file. We are doing this via a script in a seperate SQLplus window, with has nothing to do with the Java App.

No we would like to do this via a Button in the Java Application.

We thought about the following maybe solutions:

1. Doing this Export/Import stuff via an SQL Statement. This would be nice, but I think it is not possible. I searched a lot of documetation but doing something like that I couldn't find. (Or does anyone know if this is possible) But I think no - this is not the purpose of SQL and I would be very suprised if there is a possibility. But it would be so easy *sight*
2. Writing a stored procedure. Mmmmm - I haven't done this bevore and don't know much about it. Would this be a way??? Any suggestions from an expert??
3. Writing a servlet which does the stuff we do on the console so far. Ok this would work but we would like to avoid running a server for just one servlet and then the authorization problem - no there must be another way.

4.????

So, my question now - how would you do this? Any experts who could help me an have a good idea how to do this. We are open also to complete other solutions, just give us some input. Thanks a lot in advance with
kind regards
marcus Received on Wed Jun 02 2004 - 12:16:04 CDT