How do I completely empty a database while maintaining the structure?

[hgate73]

I have a database that I need to completely empty of it's contents, but leave all the tables, relationships, etc... intact. How can I do this?

 

[Thargy]

I presume that you want to delete the contents of a particular schema, not the entire db. If you did that (e.g. by emptying all the tables belonging to SYS or SYSTEM) you would disable the db permanently.

Do you mean just a schema, or really the whole db?

Regards

T

 

[hgate73]

I might be using the wrong term here. I'm "duplicating" and entire stand-alone database solution, and the method of standing up the new database instance was to import the latest full dump file. However, the new location has no need for all of the records that the first location was using, so I need to "wipe clean" all the records from the import. Is that possible?

 

[Thargy]

Yes, it's one of the exp/imp options, I think it's records=n but I'm not sure.

According to

http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1005545

it's ROWS=N, but read the documentation for yourself, to be certain.

Regards

T

 

[hgate73]

Great, thank you!