Home » RDBMS Server » Server Utilities » Exporting Schema with all the objects(no data)
Exporting Schema with all the objects(no data) [message #252901] Fri, 20 July 2007 09:53 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 12 05:05:47 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.