Hi,

I'm using PL/SQL Developer 6 with an Oracle 8 database.

PL/SQL Developer provides functionality for exporting and importing tables. I'd like to know, how this export/import works (the mechanism behind). Instead of doing the import/export manually using PL/SQL Developer, I'd like to do it "semi-automatically" from a Java application.

I'm aware, that oracle provides the imp/exp executables and there is a dbms_datapump package (but nor for Oracle 8).

Regards
ava

There are 3 formats in PL/SQL Developer:

* Oracle exp/imp format
* SQL Inserts format
* PL/SQL Developer format

The first simply calls Oracle's exp.exe and imp.exe executables with the corresponding parameters to create or read the dump file.

The 2 other formats will read the table data and write it in the form of a file with SQL insert statements or a proprietary compressed data file.

Thanks for responding. I'm using the PL/SQL Developer format export/import. Can I call this one from a Java application (using stored procedures or whatever)?

No, that is not possible because it is a proprietary format. You would have to use the Oracle or SQL Inserts format. The import can then be done from other applications by calling emp.exe (Oracle format) or by executing the SQL statements in the file (SQL Inserts format).