Export structure only

[Trevisolli]

Environment information:
* Oracle version: 10.2.0.1.0
* Operating system: Win 2003

Good afternoon, personal.
I need a help from the gurus here from the forum.

Problem:
I need to export all the structure of my database (tables, triggers, fk's, PK's etc), but without the information (Dice).

First I thought of reading my data dictionary and, create this structure with CREATE AS SELECT...

that way, it will not create the references, triggers etc I need it.

Is anyone ever going through this and / or can you give us a help?

Thanks.

[gilbertoca]

Use the EXP utility, but with the ROWS=N option
that same option for the IMP utility, even with a real dump with data.

Gilberto

[Trevisolli]

Gilberto,

again grateful for the answer.
Ball show.

[fabio.averbuch]

If you do not have tables yet in this schema you can export with the expdp utility (DataPump Export) using the CONTENTS=METADATA option