Export whole schema except data from 1 table?

  • From: Michael Ray <topshot.rhit@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 20 Jun 2006 21:58:12 -0400

I want to export a 10gR2 schema onto my laptop, but it has one huge table with data I don't need. All tables are in 1 tablespace. Is there anyway to do this without having to list the 70 other tables in a parameter file? Or export the whole thing but only import all the rows except from that one table?

"Unsupported" tweaking of the dump file perhaps? This would only be to copy onto a remote test system.
--


Sincerely,
Michael Ray
Topshot Systems LLC
--
//www.freelists.org/webpage/oracle-l


Other related posts: