current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote -1 down vote favorite

I'm using Oracle Database 11g Express Edition to set up my database. The way I currently backup my database data is through SQL Developer. (Right click on tablename > export) Which will give me a .sql file.

But, how do I do this through java code? I've looked into expdp, but I don't know how to execute it through my code, if that's even the right way to do it.

Can someone help me out here?

share|improve this question
    
you want run the exported db file in java –  suresh manda Oct 23 '13 at 11:46
    
No, I want to export the data of my database, the question is how. –  Nguyen Dinh Thien Oct 23 '13 at 12:08

1 Answer 1

up vote 0 down vote

Data Pump can be automated through the standard package DBMS_DATAPUMP. You could build a small PL/SQL procedure and call that procedure from Java. Here is an example of exporting a schema with DBMS_DATAPUMP, but it does not look very intuitive.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.