CODEWITHSUNDEEP
oracle-sqldeveloper
Pierluigi Vernetto
Pierluigi Vernetto

Reputation: 2050

Command Line Interface (CLI) for SQLDeveloper

I rely on SQLDeveloper to edit and export a schema. It works like a charm, and I can run import with sqlplus. I have tried using sqlplus to generate the same schema export, with no result.

I cannot use the Oracle expdp tool, because I need an ASCII file to be able to diff it.

So the only option I have is SQLDeveloper.

I would like to automate the export (data + DDL) with a cron job on a Linux box, but I can't find a way to use SQLDeveloper from a command line to generate the export.

Any clue?

Upvotes: 0

Views: 2231

Answers (1)

Kyle Kochis
Kyle Kochis

Reputation: 669

Short answer: no.

For just the schema side of things you may want checkout show create table equivalent in oracle sql which will get you the SQL source of the DDL.

Are you sure you want an ASCII file for the automated export of an entire DB though? I would be surprised if you really want to diff an entire export of a DB. This SO Answer may help a little though.

If you really want to get a full data dump plus DDL you will have to write your own script that gets the DDL as described in the first link and then select * and process each result into a sql insert.

Upvotes: 1

Related Questions