ORA-00900: invalid SQL statement while exporting an Oracle database from Java

Question

Executing below command from the command line is successful, but executing the same command from a Java class throws an "invalid SQL statement"-error.

EXPDP DCR/DCR2017 DIRECTORY=D33 DUMPFILE=DCR.DMP SCHEMAS=DCR

Java Code:

  String sql ="EXPDP DCR/DCR2017 DIRECTORY=D33 DUMPFILE=DCR.DMP SCHEMAS=DCR";
  Class.forName("oracle.jdbc.driver.OracleDriver");  

  Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/orcl","DCR","DCR2017");
  PreparedStatement prepareStatement = connection.prepareStatement(sql);
  boolean execute = prepareStatement.execute();
  System.out.println(execute);

expdp is a command-line tool, as you already know as you said that was sucessful. It is not a SQL command. Hence the error you get. You would see the same thing trying to do that from, say, a SQL*Plus prompt. There is PL/SQL package access to data pump, but do you really want to do it that way, or from Java from a system command? Why not just do it from the command line? — Alex Poole
– Alex Poole, Commented Jul 28, 2018 at 15:15
yes, expdp is a command line statement. then what should be the SQL statement For this. As I want to control the export and import From Java that's why I am trying to use it from Java — kali53
– kali53, Commented Jul 28, 2018 at 15:18
There isn't a single SQL statement, but you could work with the API if you really wanted to. Or you can call expdp via getRuntime().exec(). — Alex Poole
– Alex Poole, Commented Jul 28, 2018 at 15:22

eaolson · Accepted Answer · 2018-07-29 14:46:04Z

1

You cannot call expdp from SQL. It's a command-line function. There is a PL/SQL API for that called dbms_datapump, which you can call from PL/SQL.

answered Jul 29, 2018 at 14:46

eaolson

15.2k7 gold badges46 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ORA-00900: invalid SQL statement while exporting an Oracle database from Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related