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?
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.
Previous Topic: SQL Loader control file to create duplicate row
Next Topic: SQL LODER - Single/Multiple csvs load Multiple tables
Goto Forum:
  


Current Time: Wed Dec 07 07:12:30 CST 2016

Total time taken to generate the page: 0.11709 seconds