Home » RDBMS Server » Backup & Recovery » export user's structure
export user's structure [message #241653] Wed, 30 May 2007 05:35 Go to next message
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?
Re: export user's structure [message #241682 is a reply to message #241653] Wed, 30 May 2007 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle version?

Regards
Michel
Re: export user's structure [message #241699 is a reply to message #241682] Wed, 30 May 2007 07:55 Go to previous messageGo to next message
albuq
Messages: 8
Registered: May 2007
Location: Portugal
Junior Member
sorry...9i
Re: export user's structure [message #241727 is a reply to message #241699] Wed, 30 May 2007 08:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at dbms_metadata package.

Regards
Michel
Re: export user's structure [message #241746 is a reply to message #241653] Wed, 30 May 2007 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 25427
Registered: January 2009
Location: SoCal
Senior Member
EXP ROWS=NO
Re: export user's structure [message #241756 is a reply to message #241746] Wed, 30 May 2007 10:03 Go to previous message
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: Sat May 27 20:10:01 CDT 2017

Total time taken to generate the page: 0.16712 seconds