Oracle: exporting only schema

Question

Hello

I have an Oracle 10g database, and now I need to export, if possible, only the schema.
(Only table structures with index etc... without data!)

Is this possible with exp/imp or do I need expdp/impdp?

Greets

Answer 1

It is possible with exp, using parameter ROWS=N.

10g documentation is here.

Data pump is preferred these days though; the equivalent parameter is CONTENT=METADATA_ONLY.

Answer 2

If you are only interested in the table definitions with their constraints and indexes you can also do an export using Oracle's SQL Developer