Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Export whole schema except data from 1 table?

Export whole schema except data from 1 table?

From: Michael Ray <topshot.rhit_at_gmail.com>
Date: Tue, 20 Jun 2006 21:58:12 -0400
Message-id: <4498A7B4.3000103@gmail.com>


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
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 20 2006 - 20:58:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US