Re: Export whole schema except data from 1 table?

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: topshot.rhit@xxxxxxxxx
  • Date: Tue, 20 Jun 2006 22:40:56 -0500

Michael,

Time to learn the DBAs friend.
select table_name||"," from user_tables

Dennis Williams


On 6/20/06, Michael Ray <topshot.rhit@xxxxxxxxx> wrote: 

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2006