OraFAQ Forum: Backup & Recovery » export user's structure

Home » RDBMS Server » Backup & Recovery » export user's structure

Wed, 30 May 2007 05:35

albuq
Messages: 8
Registered: May 2007
Location: Portugal

Junior Member

I want to export user's structure. This means that i don't want to export the data, only the structure of tables and so on.
Anybody knows?

Wed, 30 May 2007 07:06

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Oracle version?

Regards
Michel

Wed, 30 May 2007 07:55

albuq
Messages: 8
Registered: May 2007
Location: Portugal

Junior Member

sorry...9i

Wed, 30 May 2007 08:48

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have a look at dbms_metadata package.

Regards
Michel

Wed, 30 May 2007 09:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

EXP ROWS=NO

Wed, 30 May 2007 10:03

albuq
Messages: 8
Registered: May 2007
Location: Portugal

Junior Member

Thank you

Previous Topic:	What is the System Change Number?
Next Topic:	Script for Cold Backup

Goto Forum:

]

Current Time: Fri May 15 21:47:55 CDT 2026