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).
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: 4571
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
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?
Previous Topic: pb transferring samples with capacity planner
Next Topic: Restore job using Enterprise Manager
Goto Forum:
  


Current Time: Mon May 16 19:49:17 CDT 2022