Home » RDBMS Server » Server Utilities » Export all objects in a user schema without data
Export all objects in a user schema without data [message #177927] Sun, 18 June 2006 01:46 Go to next message
msgforsunil
Messages: 26
Registered: November 2005
Junior Member
Hi All,

Is there any way to export entire schema(Table, Views, Indexes, Packages, Procedures, Functions, Triggeers, Types, Sequence, Synonymns, Java Classes objects...) of an user without data?

Thanks,
Sunil

Report message to a moderator

Re: Export all objects in a user schema without data [message #177937 is a reply to message #177927] Sun, 18 June 2006 03:42 Go to previous messageGo to next message
Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You could try with ROWS=N, for example

> EXP scott/tiger@database FILE=scott.dmp ROWS=N

For more options type EXP HELP=Y, or - even better - read the documentation.

Report message to a moderator

Re: Export all objects in a user schema without data [message #177939 is a reply to message #177937] Sun, 18 June 2006 04:36 Go to previous messageGo to next message
msgforsunil
Messages: 26
Registered: November 2005
Junior Member
Thanks,
1. Will this export Views, Indexes, Packages, Procedures, Functions, Triggeers, Types, Sequence, Synonymns, Java Classes objects?

2. How do i do it using DBMS_METADATA command?
3. I guess DBMS_METADATA command should be run as DBA and not as normal user. If run as DBA then how do we mention the which user schema to export?

Thanks again.

Report message to a moderator

Re: Export all objects in a user schema without data [message #177949 is a reply to message #177939] Sun, 18 June 2006 07:07 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> How do i do it using DBMS_METADATA command?
Search the forum, before posting.
http://www.orafaq.com/forum/t/59966/42800/


>>I guess DBMS_METADATA command should be run as DBA and not as normal user.
Not essentially. Anyone can run this.
http://www.orafaq.com/forum/m/130430/42800/?srch=dbms_metadata#msg_130430
http://www.orafaq.com/forum/m/151577/42800/?srch=mddemo.sql#msg_151577

Report message to a moderator

Previous Topic: Export
Next Topic: Importing objects of another user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 00:38:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.