Home » RDBMS Server » Enterprise Manager » How to take oracle database dump without data ?
How to take oracle database dump without data ? [message #68491] Fri, 05 December 2003 06:14 Go to next message
shankar
Messages: 29
Registered: January 2002
Junior Member
How to take oracle database dump without data ?
I mean the dump file should contain only the blank database table structures without any records (data).

Report message to a moderator

Re: How to take oracle database dump without data ? [message #68492 is a reply to message #68491] Sat, 06 December 2003 05:15 Go to previous messageGo to next message
Frank Naude
Messages: 4596
Registered: April 1998
Senior Member
Hi,

Export the database with ROWS=NO. See the Oracle
Import/ Export FAQ for details. Example:

$ exp system/manager file=dbstructure.dmp rows=no

Best regards.

Frank

Report message to a moderator

Re: How to take oracle database dump without data ? [message #68830 is a reply to message #68492] Thu, 28 October 2004 13:47 Go to previous message
bobw
Messages: 1
Registered: October 2004
Junior Member
When I import a no data export into another like database, I noticed that the file for the precreated tablespaces in the destination DB get allocated as if data is being populated along with the creation of the objects, WHY?

Report message to a moderator

Previous Topic: pb transferring samples with capacity planner
Next Topic: Restore job using Enterprise Manager
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 23 01:50:23 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.