OraFAQ Forum: Server Utilities » Exporting Schema with all the objects(no data)

Home » RDBMS Server » Server Utilities » Exporting Schema with all the objects(no data)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exporting Schema with all the objects(no data) [message #252901]

Fri, 20 July 2007 09:53

Chandra Vedantham
Messages: 14
Registered: November 2004

Junior Member

Hi Gurus,
Can I export a schema from a database and the export shuold contain all the objects and no data and index data?
Can you please advise me on how to acheive this using the EXPORT utility?

Report message to a moderator

Re: Exporting Schema with all the objects(no data) [message #252902 is a reply to message #252901]

Fri, 20 July 2007 09:56

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

YES YOU CAN.
You want to export meta data only??

indexes=n
rows=n

[Updated on: Fri, 20 July 2007 09:57]

Report message to a moderator

Re: Exporting Schema with all the objects(no data) [message #252905 is a reply to message #252902]

Fri, 20 July 2007 10:10

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

if you using 10g then you can use metadat caluse in export

Quote:

The following is an example of using the CONTENT parameter:
> expdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp CONTENT=METADATA_ONLY
This command will execute a schema-mode export that will unload only the metadata
associated with the hr schema. It defaults to a schema-mode export of the hr schema
because no export mode is specified.

Report message to a moderator

Previous Topic:	SQL Loader control file to create duplicate row
Next Topic:	SQL LODER - Single/Multiple csvs load Multiple tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:36:42 CDT 2024